Subject Re: [firebird-support] Deactivating transactions for a while
Author Ivan Prenosil
> I am trying to insert a big amount of data in my database but the process is 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.

What can slow down the db server considerably are file operations, so try do deactivate filesystem.

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/