09-21-2017 04:51 AM
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.