[thelist] Super Slow Query

Casey Crookston caseyc at IntelliSoftmn.com
Thu Jul 5 11:38:42 CDT 2007

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.







More information about the thelist mailing list