What is the difference between the oldest active transaction and next
transaction?

Set

--- In firebird-support@yahoogroups.com, Andrea Chiado' Piat wrote:
> Hi,
>
> I'm writing an application for a my costumer.
> This program every 3 seconds read some informations from a PLC and
> update a table where there are 64 rows. So it do 64 updates every 3
> seconds. The program connects firebird, update and commits 64 times
> and then disconnect from firebird.
> Also an other application in 4 pc, every 3 seconds, read all 64
> records from that table and refresh some informations on video.
> After about a week there is a performance degradation and my
> database is about 250 mb but rows in that table are always 64. I
> schedule every night a backup with gbac scheduler so it do a garbage
> collection i think. If I'm not wrong firebird would reuse allocated
> space so it would grow for a day and than reuse the space. It's
> right?
> Sweep is set to 0, fw is on.
> I use gemini odbc for connect to firebird.