> It says "Out of memory".
>
> My program is made in D5 Enterprise using TIBQuery.
> I run thruogh some 200.000 records and these cover 2 months of
> transactions.
> When I start I create or update some 160000 records in two tables.
> When I change month I do the same, and at the end again.
> So I will at the end have created or updated some 500.000 records.
This is really a Delphi/IBX question, but..
If you are using TIBQuery make sure the unidirectional property is set to
'true', or all the records will be buffered in memory 'in the client'.
Better still, use a TIBSQL, which does not buffer stuff and is a lot
'thinner'.
Even better, move all this processing to Store Procedures, so it is done
server side.
Phil
--
Linux 2.4.4-4GB
6:53am up 14 days, 12:42, 1 user, load average: 0.30, 0.14, 0.05