Subject | Re: [firebird-support] Deactivating transactions for a while |
---|---|
Author | Martijn Tonies |
Post date | 2006-02-17T17:43:50Z |
> I am trying to insert a big amount of data in my database but the processis too slow even thougth I have deactivated the indexes in the database. I
believe it could be due to the transaction management and I would like to
deactivate transaction management during the data load. Is it there a
sentence or something else that lets me do this. Thanks in advance
>You cannot de-activate transactions.
But ... it's not clear if you're doing 1 transaction per record
inserted, or if you're doing "batches" of, for example, 10000
records per transaction.
What are you doing?
Either way, doing batches will be quicker.
Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com