--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:

> Greetings,
>
> 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" :) )
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.

Best regards,
Alexander