Subject | Re: database ballooning problem |
---|---|
Author | Adam |
Post date | 2005-09-06T05:43:52Z |
> Duncan was referring to IBO's Savepoint method, not the SQL SAVEPOINTIBO's
> statement. This is a client-side method (that predates Firebird's
> SAVEPOINT syntax by about 6 years), that allows you to perform a
> CommitRetaining on all work so far posted for a transaction. So
> Savepoint method indeed creates one record version for each record iton
> updates; and it also enables the user to go back and do more updates
> these records, thus propagating more record versions that won't getAh, makes sense in that context then. Sounds to me like something to
> garbage-collected.
>
avoid (especially considering real savepoints are available in Firebird
1.5+).
Adam