Subject | Re: [firebird-support] Deactivating transactions for a while |
---|---|
Author | Martijn Tonies |
Post date | 2006-02-17T18:05:10Z |
> I have a program that duplicates some part of my database and do itsentece 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
> Thanksprocess
>
> Lorenzo
>
> Martijn Tonies <m.tonies@...> escribió:
>
>
> > I am trying to insert a big amount of data in my database but the
> 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.