| Subject | Re: [firebird-support] Bulk upload options |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2018-05-18T18:59:28Z |
| 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.
[]s
Carlos
www.firebirdnews.org - www.FireBase.com.br