Improving query performance under increased load

[AA]

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

[Michael Levy]

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