-
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.
-
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.
-
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
-
Forum Rules
|
|