DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: query response time

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    let's say my database is READ-ONLY.
    if i do some query and it take 1 second to finish.

    1.
    what would i expect to happen when 1000 people do the same query at the same time?

    2.
    a little bit more than 1 second?

    3.
    did each of them expect the same response time or
    some may take longer than other?
    guru is on the way!!!!

  2. #2
    Join Date
    Apr 2001
    Posts
    219
    It all depends on a lot of factors like:
    1. Dedicated or MTS
    2. System Resources (CPU, Memory)
    3. Cursor Reuse

    If you are using dedicated you may a slight performance boost or lag depending greatly on system resource. I would say that you should expect a slight performance degradation, but not much as long as you have ample resource to support such a load.
    ______________________
    Applications come and go,
    but the data remains!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well it must lag, more users = less throughput although indeed it depends on many factors as zaggy suggested

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width