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.
What is wrong?
Any suggestions?

Thank you
Andrea Chiado' Piat