Hmm. Something I just discovered when playing around. Here's the gridview's data source: <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:connect_big %>" SelectCommand="SELECT ... WHERE ... AND (b.region_id = @region_id)"> <SelectParameters> <asp:ControlParameter ControlID="drpRegions" Name="region_id" PropertyName="SelectedValue" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> Now, if I take out the @region_id and replace it with a hard coded value, then Bingo! The reslts are instant. @region_id is, of course, a paramater populated from the selected value of the dropdown, drpRegions. >From looking at that drop down, everything appears to be in order, but for some reason, when trying to execute this gridview and query at runtime, it hangs. Any idea why? Thanks, Casey -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Anthony Baratta Sent: Thursday, July 05, 2007 11:57 AM To: thelist at lists.evolt.org Subject: Re: [thelist] Super Slow Query 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 ! > -- * * 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 !