Strange query response time

[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?

 

[W.G. Ryan eMVP]

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.

 

[Sahil Malik]

Replace the webpage with a simple ConsoleApp. Post code - and results.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Patrice]

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