Subject Re: [ib-support] Out of memory
Author Phil Shrimpton
On Monday 10 February 2003 08:43, you wrote:


> I have an appl. that contects to an Firebird DB (1.0).
> In my appl. I have made a rutine, that select 228.000 records, and
> parse through each of them.
> For each record I call a stored procedure that either update another
> record or insert a record.
> Project xxx raised exception class EOutOfMemory with message "Out of
> memory". Process stopped.

Setting unidirectional=true will prevent all 228.000 records being buffered
in memory on the client side.

Unless you have a need to display all 228.000 of these records in the client
app, I would switch the whole lot to a stored procedure, so no record
fetching to client will be needed at all.


Linux 2.4.4-4GB
9:27am up 27 days, 15:16, 1 user, load average: 0.42, 0.11, 0.03