[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