Re: Out-of-memory with large dataset
Re: Out-of-memory with large dataset
- Subject: Re: Out-of-memory with large dataset
- From: Guido Neitzer <email@hidden>
- Date: Wed, 11 May 2005 18:07:18 +0200
On 11.05.2005, at 17:36 Uhr, Jan Willem Luiten wrote:
I'm using WO 5.2 in combination with PostgreSQL 8. I have a table
containing well over 600.000 tuples. With a WODisplayGroup on this
table I get an out of memory error. Anyone on the list knows wether
this would happen with other DB's as well or is this a problem
between EOF and PostgreSQL?
Any hints on how to solve this are more than welcome.
Place a fetch limit on your EOFetchSpecification (or a limiting
qualifier).
If you just use the displaygroup, EOF tries to fetch all the rows to
the memory which is bad. Alternative is to use a BatchingDisplayGroup
from ProjectWonder.
Works quite well. If you need a code example, send me an email.
cug
_______________________________________________
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