Strange query response time

  • Thread starter Thread starter Jeremy Chapman
  • Start date Start date
J

Jeremy Chapman

I've got a query where if I run it from query analyzer it takes about 1
second, but if I do it from an aspnet page, it takes about 54 seconds. Can
anyone suggest reasons that this might be?
 
It can be a bunch of stuff. HOw are you calling the query? With a
DataTable/DataSet? If so, remember that QA pulls over the data as it's
requested but if you use a DataTable then all of the data is pulled over in
one swoop.
 
Are you sure you time just the request in the ASP.NET page ? In particular
don't you take into account the time needed to display the result ?

Patrice
 
Back
Top