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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to