Re: Report generation: How to avoid "java.lang.OutOfMemoryError: Java heap space"?
Re: Report generation: How to avoid "java.lang.OutOfMemoryError: Java heap space"?
- Subject: Re: Report generation: How to avoid "java.lang.OutOfMemoryError: Java heap space"?
- From: Fabian Peters <email@hidden>
- Date: Mon, 1 Oct 2007 09:26:09 +0000
Hi Andrew,
I'm using the ERXFetchSpecificationBatchIterator now, which makes
handling batches very straightforward. Anyway, the batching itself
was working as expected, the problem lay elsewhere in my code. I'm
using postgresql.
cheers, Fabian
Am 30.09.2007 um 06:20 schrieb Andrew Lindesay:
Hello Fabian;
What I tend to do is to raw-row fetch the PK's for the objects
involved and then turn those into GID's. Then I loop through a
hundred or so at a time with a new EC each time. On each loop,
those GID's get turned into "proper enterprise objects" using one
big fetch. I then manually assemble (no components) CSV from
this. The CSV is then either streamed into a gz-compressed
java.io.ByteArrayOutputStream or, in situations where where volumes
are likely to exceed the virtual-machine's memory, I use a gz'ed
blob-streaming system that I developed.
This seems to work ok for my situations. Can I ask what DB you are
using?
cheers.
I'm trying to set up a simple reporting component, output of which
is to be used in a statistical analysis. It's basically a
WORepetition wrapped around about 40 WOStrings, supposed to render
a long
...
Since I'm a bit lost right now, I hope someone can push me in the
right direction...
___
Andrew Lindesay
technology : www.lindesay.co.nz
business : www.silvereye.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden