Improving query performance under increased load


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Improving query performance under increased load

Hybrid View

  1. #1
    AA Guest

    Improving query performance under increased load


    We have an ASP page that does a simple select on a master table containing
    less than 1000 rows and displays in a dropdown. When multiple users are
    running the same query simultaneuosly, the reponse time grows exponentially.


    For eg. the query takes 5 seconds to return this data for a single user and
    52 secs for 10 concurrent users.

    Is there any way to cache the data or to improve the performance?

    Database: MS SQL Server

  2. #2
    Michael Levy Guest

    Re: Improving query performance under increased load

    I've discussed this with a co-worker. We're wondering what you have the
    cursor location set to: client or server and if you're going through a
    component that was written with VB.

    -Mike
    --
    Michael Levy MCDBA, MCSD, MCT
    michaell@gasullivan.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center