|Subject||Re: [firebird-support] Bulk upload options|
|Author||Carlos H. Cantu|
|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.
www.firebirdnews.org - www.FireBase.com.br