Stored Procedure Stage Performance Issue
Posted: Fri Dec 02, 2005 9:58 am
Hi,
We are using Ascential DS 7.5.1A with the following patches applied:
75003,
80895,
80559,
80036,
76017,
20959
The Stored Procedure Stage caches all rows before it starts to write its output. This causes many gigabytes of memory to be used and the job to be aborted. I have tried to use no buffer and to set the job to parallel execution. Seems the default is sequential. Still no luck.
The only way I can get procedures to execute effectively is through the ODBC Enterprise Stage.
Is there a way to have the stored procedure stage writes its output streaming as the other stages do?
We are using Ascential DS 7.5.1A with the following patches applied:
75003,
80895,
80559,
80036,
76017,
20959
The Stored Procedure Stage caches all rows before it starts to write its output. This causes many gigabytes of memory to be used and the job to be aborted. I have tried to use no buffer and to set the job to parallel execution. Seems the default is sequential. Still no luck.
The only way I can get procedures to execute effectively is through the ODBC Enterprise Stage.
Is there a way to have the stored procedure stage writes its output streaming as the other stages do?