Results 1 to 3 of 3

Thread: Not specified

  1. #1
    Di Guest

    Not specified


    Is it possible that a stored procedure runs slower when called by an application,and runs faster when executed as 'exec xxxxx' on query analyzer?
    It's actually happening to us.Any clue??
    thanks.
    Di.

  2. #2
    Jurgen Hintze Guest

    Not specified (reply)

    What is the procedure doing ?

    Does it return output ?

    How is the procedure called : via ODBC , OLEDB, ... ?

    ------------
    Di at 1/18/2002 10:58:36 PM


    Is it possible that a stored procedure runs slower when called by an application,and runs faster when executed as 'exec xxxxx' on query analyzer?
    It's actually happening to us.Any clue??
    thanks.
    Di.

  3. #3
    Juergen Leis Guest

    Not specified (reply)

    Did you check and compare the connection settings
    ( ANSI_NULLS, QUOTED_IDENTIFIER, ... )
    Different settings may result in different execution plans.

    ------------
    Jurgen Hintze at 1/23/2002 3:59:26 AM

    What is the procedure doing ?

    Does it return output ?

    How is the procedure called : via ODBC , OLEDB, ... ?

    ------------
    Di at 1/18/2002 10:58:36 PM


    Is it possible that a stored procedure runs slower when called by an application,and runs faster when executed as 'exec xxxxx' on query analyzer?
    It's actually happening to us.Any clue??
    thanks.
    Di.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •