cancel
Showing results for 
Search instead for 
Did you mean: 

Stored procedure versus multiple sql execute snaps

binupaul
New Contributor II

I have a SQLServer stored procedure snap with mostly SELECTs from several tables (not in an ultra pipeline). If I break up the stored procedure and substitute the SQLServer stored procedure snap with a series of sequential SQL execute and mapper combination snaps (to be used in an ultra pipeline), will it cause considerable performance drop? The stored procedure will be replaced by at least 12 SQL Execute and mapper snaps. I am assuming that the connection from the first SQL Execute would be reused for subsequent snaps or a pool would be used by the execution system.

0 REPLIES 0