December 7th, 2003, 01:26 PM
Urgent Exec. time of SP btw Query Analyser and ASP
i have a problem in executing a sp through Query Analyser and ASP command object.
The execution time of sp in Query Analyser is taking 2 sec and the same exec statement is getting time out through ADO command object in ASP.
exec USP_ENQUIRY_SEARCH @ENROLMENT_NO='BLR',@GROUP_NAME='IGATE'
and all remaining queries r working fine and execution time between Query Analyser and ASP also same.so there will not be a problem of Networking stuff.
Iam recompiled the sp so many times and i rebuiled the indexes that iam using in the query also and i updated the statistics also..but the same problem is repeating..
what will be the problem?can any one guide me.
December 8th, 2003, 02:07 PM
How are you connecting to the database in the ASP app? Is this an ADO connection or an ODBC connection you're making? Also, is it possible that your ASP app is running some previous query that has the tables locked?
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo