Subject Re: [firebird-support] Bulk upload options
Author Carlos H. Cantu
Re: [firebird-support] Bulk upload options

After this, transfer from local database-backup to local destiny using parametrizes queries.
It´s fast, but you need to commit after several inserts because after some times the transaction will be slow down.

Afaik, during a restore, gbak writes all the database data mostly in a single transaction, unless -O is specified. I don't notice this slowdown in gbak, so maybe it is something related to your access component?

Also, gbak does that in an exclusive connection. I don't know about yours.

Carlos -