Output large xml from resultset

Question

We have an application in which an XML string is created from a stored proc resultset and transformed using XSLT to return to the calling servlet. This work fine with smaller dataset but causing out of memory error with large amount of data. What will be the ideal solution in this case ?

Answer 1

XSLT transformations, in general, require the entire dataset to be loaded into memory, so the easiest thing is to get more memory.

If you can rewrite your XSLT, there is Streaming Transformations for XML which allow for incremental processing of data.