[thelist] Super Slow Query
Anthony Baratta
anthony at baratta.com
Thu Jul 5 11:56:51 CDT 2007
You need to start adding timers to you code. Just log the time at specific locations in your code and see where the slow down is. I would suspect that the error is not in the query itself. Maybe there is a looping problem over the record set, or maybe building the grid view, or somewhere else. Timers all over the code will tell you that.
-----Original message-----
From: "Casey Crookston" caseyc at IntelliSoftmn.com
Date: Thu, 05 Jul 2007 09:38:42 -0700
To: thelist at lists.evolt.org
Subject: [thelist] Super Slow Query
> Hi All,
>
>
>
> In VS2005 / SQL 2000, I've got a query which continually times out when
> executed via a web app. It's a query that generates a report and then
> displays the data in a gridview on a web page.
>
>
>
> When I copy the query into SQL 2000's query analyzer and execute it, it
> takes 00:00:01 to run. And when I go into "Configure Data Source"
> within the SQLDataSource on the page and test the query, it returns a
> set of data almost instantly.
>
>
>
> But, at run time, the page times out every time on this query.
>
>
>
> ?????!
>
>
>
> Casey
>
>
>
>
>
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list