Page 1 of 1
How memory intensive is the XML output stage?
Posted: Mon Sep 13, 2010 1:51 am
by poornimasai
I have a job that becomes non-responsive after it gets to the XML Output stage. Is there a memory setting I can change to experiment with?
Is this even memory intensive?
Posted: Mon Sep 13, 2010 3:26 am
by eostic
It "could" be. But also, consider that the XML Output Stage is a sort of aggregating stage....unless you are using a trigger, it has to collect all of your rows before letting anything go....it also could just be a reflection of your job....if the "whole job" is your "whole xml", then it will be waiting for all the other rows to arrive before it finishes. If you sort your data coming in along its nested nodes, and the XML is not too many elements or attributes, it's fairly quick.....it depends.....but it's definitely not a screamer. How complex is your xml? Is it coming out correctly?
Ernie