> 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.
Phil
--
Linux 2.4.4-4GB
9:27am up 27 days, 15:16, 1 user, load average: 0.42, 0.11, 0.03