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.
Printable View
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.
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.
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.