Stored procedure running slower through DI

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 :uk: (BOB member since 2007-04-19)