Subject | Re: [firebird-support] Deactivating transactions for a while |
---|---|
Author | Ivan Prenosil |
Post date | 2006-02-17T17:47:14Z |
> I am trying to insert a big amount of data in my database but the process is too slow even thougth I have deactivatedWhat can slow down the db server considerably are file operations, so try do deactivate filesystem.
> 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.
If it does not help, tell us more
- do you have some triggers ?
- do you use prepared statements ?
- you don't commit after each inserted row, do you ?
Ivan
http://www.volny.cz/iprenosil/interbase/