Strange query response time

9 Dec 2004 5:36 PM

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?

9 Dec 2004 5:42 PM

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.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com

Show quote

"Jeremy Chapman" <NoSpam@Please.com> wrote in message
news:ebnFiWh3EHA.3908@TK2MSFTNGP12.phx.gbl...
> 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?
>
>

9 Dec 2004 6:08 PM

Sahil Malik

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

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

Show quote

"Jeremy Chapman" <NoSpam@Please.com> wrote in message
news:ebnFiWh3EHA.3908@TK2MSFTNGP12.phx.gbl...
> 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?
>
>

10 Dec 2004 8:33 AM

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

--

Show quote

"Jeremy Chapman" <NoSpam@Please.com> a écrit dans le message de
news:ebnFiWh3EHA.3908@TK2MSFTNGP12.phx.gbl...
> 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?
>
>