Stored procedure running slower through DI

system · April 23, 2008, 1:16pm

A stored procedure completed with in 4 minutes in db engine is running more than 20 minutes to finish through DI job.
How to tune the stored procedure calls for better performance

Raj

rajbodi (BOB member since 2008-03-17)

system · April 25, 2008, 3:05pm

How is the procedure being called? Is it a function being called in a mapping? Is it a procedure being called in a script?

djlaplant (BOB member since 2004-04-03)

system · April 28, 2008, 12:03pm

Procedure is being called in script

rajbodi (BOB member since 2008-03-17)

system · April 29, 2008, 8:41am

DI puts a transaction around the DB calls, see https://bobj-board.org/t/102747

If this is SQL, either put into the SP as the first item (before it does anything to manipulate data)…

SET IMPLICIT_TRANSACTIONS OFF

…or in the script within the sql function.

HuwD (BOB member since 2007-04-19)