| Subject | RE: [firebird-support] Compacting the database from a App |
|---|---|
| Author | Helen Borrie |
| Post date | 2010-10-15T22:38:08Z |
At 07:06 AM 16/10/2010, you wrote:
On that subject, do be aware that all read-write transactions, and all read-only transactions except those in READ COMMITTED isolation, will be affected if you don't commit them regularly. Don't be fooled by thinking that operations that don't update anything (such as SELECT statements) are exempt...they're not.
BTW, as Chief List Grouch, may I ask you to avoid top-posting in these lists, and to trim your replies. Ta.
^ heLen ^
>So in other words I should not worry about having a compact function withinThat part is true. The other part is that now you are working in a transactional environment. Take very good care to complete transactions in a timely way - otherwise you will build up a lot of garbage that, in large quantities, will adversely affect impact performance as time goes by.
>the software
On that subject, do be aware that all read-write transactions, and all read-only transactions except those in READ COMMITTED isolation, will be affected if you don't commit them regularly. Don't be fooled by thinking that operations that don't update anything (such as SELECT statements) are exempt...they're not.
BTW, as Chief List Grouch, may I ask you to avoid top-posting in these lists, and to trim your replies. Ta.
^ heLen ^