Ridiculously Slow Sorting? -- sql server (microsoft)

Mark Olbert
12/23/2005 12:21:01 PM

Can someone explain why SqlServer2005 returns the following query very quickly (i.e., under 1 second):

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1

but takes almost 20 seconds to return the following query:

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1 ORDER BY seq_num

The number of records in both cases is trivial, i.e., less than 10.

Mark Olbert
12/23/2005 12:24:39 PM

I should mention this occurs in an ASP.NET 2 website.

[quoted text, click to view]

Mark Olbert
12/24/2005 7:15:09 AM

For those who might run into this same slow sorting behavior:

I'm not sure exactly what I did to "cure" it, but fiddling around with the configuration of SqlServer2005 services on my server, and
with the "surface area" management utility, apparently resolved the problem (I didn't do anything to the installation on my client
machine where the problem appeared).

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : Ridiculously Slow Sorting?