Subject Re: no_auto_undo
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:
> Does this mean that I can use this option safely,

AFAIK yes.

> and even if I roll
> back, nothing will be commited...?

Hmm, talk of two Slavs in English :) If you roll back, no _changes_
will be _never_ commited. With auto undo enabled on rollback small
amount of changes can be discarded in memory as if they were never
made. After this _transaction's state_ can be safely changed to
"commited" since there are no changes within it's context, exactly as
if you commit read only transaction. Changes are undone and Oldest
Transaction is'nt fixed, no bad effect on garbage collection.

> 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?

Yes. At least FB developers says me so and seems I could'nt
understand them wrong, we spoke in Russian :)

Best regards,
Alexander.