| Subject | Re: [firebird-support] Help |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-06-02T15:14:36Z |
At 11:02 AM 2/06/2005 -0400, you wrote:
especially if you don't have a lot of memory on the server. The server
builds up an auto-undo log structure in memory for inserts, which will be
reset when the transaction commits.
If you have control over the transaction at API level, you could disable
this logging by setting the isc_tpb_no_auto_undo parameter.
./heLen
>Hi,It's advisable to commit in batches of about 5000 - 8000 records,
>I'm migrating data from DBFs to firebird tables. The thing is that when the
>ammount of records is bigger (10000 records), the inserts become slower.
>Do I have to change something ?. Do I have to perform some clean up?
especially if you don't have a lot of memory on the server. The server
builds up an auto-undo log structure in memory for inserts, which will be
reset when the transaction commits.
If you have control over the transaction at API level, you could disable
this logging by setting the isc_tpb_no_auto_undo parameter.
./heLen