[thelist] Super Slow Query
Luther, Ron
Ron.Luther at hp.com
Thu Jul 5 13:45:57 CDT 2007
Casey Crookston noted:
>>Yes. Like I say, the exact same query in Query Analyzer takes 0 to 1
seconds to complete.
Hi Casey,
I would check on the 'exact same' assumption by printing out the query
from the webpage just before it executes.
Sometimes a small variable spelling error or something can cause the
value being sent to the db to be undefined (and hang) when *I* think
it's sending a numeric "42" ... Or a character '42' when I think its
sending numeric ... Etc.
Or special characters get embedded when I'm not expecting them.
Good Luck,
RonL.
More information about the thelist
mailing list