[thelist] Super Slow Query

[Casey Crookston]

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