Subject Re: [firebird-support] Deactivating transactions for a while
Author Martijn Tonies
> I have a program that duplicates some part of my database and do it
sentece by sentence and it is very slow it last more than five hours
>

Try doing multiple records per transaction then.

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

> Thanks
>
> Lorenzo
>
> Martijn Tonies <m.tonies@...> escribió:
>
>
> > 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. 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.