Improve performance of stored procedure called by java application

Improve performance of stored procedure called by java application

We have a stored procedure being called from our java web service.  It takes 1 sec from MS SQL management studio but takes 32 sec from the client of web service.

Java code:

Stored Procedure:

Few setting which will improve performance of stored procedure

set implicit_transactions off

set transaction isolation level READ COMMITTED

So new stored procedure will be

Leave a Reply

Your email address will not be published. Required fields are marked *