Subject | Re: no_auto_undo |
---|---|
Author | Alexander V.Nevsky |
Post date | 2004-04-21T18:42:59Z |
--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:
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.
understand them wrong, we spoke in Russian :)
Best regards,
Alexander.
wrote:
> Does this mean that I can use this option safely,AFAIK yes.
> and even if I rollHmm, talk of two Slavs in English :) If you roll back, no _changes_
> back, nothing will be commited...?
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,massive-ness of
> except that speed may increase/decrease depending on the
> 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.