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
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.
Michael Levy MCDBA, MCSD, MCT
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL