Alexander V.Nevsky wrote:

> --- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
> wrote:
>>I'm some old post I read that: To make large inserts go faster, one
>>could connect with a database parameter block that includes
>
> 'no_auto_undo'
>
>>I'm interested to know what are the implications of using this.
>
> AFAIK some amount of changes (don't ask me how much is "some" :) )

I won't :)

> FB tries to hold in memory and, if transaction is rolled back
> afterwards, undoes this changes and marks transaction as "commited" to
> avoid OIT fixing by rollback. When "some" is finished, changes are
> written onto disk and if transaction will be rolled back, it will be
> marked as rolled back. On mass changes this becomes ineffective
> because of unknown for me details of algorithn and we can use
> mentioned option to switch this mechanism off when going to perform
> mass changes.

Does this mean that I can use this option safely, and even if I roll
back, nothing will be commited...?

As I understood, when using this option everything works as usual,
except that speed may increase/decrease depending on the massive-ness of
changes. Is that Correct?

P.S. Thanx for the quick reply

--
Milan Babuskov
http://fbexport.sourceforge.net