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?

Do you commit the transaction every time after that you've read the reocrds
for information on video ?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81