#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    4
    Rep Power
    0

    Unhappy Urgent Exec. time of SP btw Query Analyser and ASP


    hi Experts,
    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.
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,638
    Rep Power
    4247
    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

IMN logo majestic logo threadwatch logo seochat tools logo