Subject The Database file is growing exponentialy with UPDATE query
Author pierre.ghislain
Hi there!

I am using Firebird 2.0.3 (but I experience the same problem with
Firebird 1.5) on Windows XP. Default installation: Classic Server.

Programming with Delphi 7 and using Interbse driver.

I have a table that I must UPDATE every 250 ms...

Well, the database file grow, grow, grow... so much that FireBird,
after 1 day, is becomming very slow...

The Database starts with 1700 Kb... and after one day it reaches
25.000 Kb.... 35.000 kb...

So, I have resolve the problem making a backup and there after a
restore and... marvelous, the restored database go back to the 1700
Kb size...

Can somebody come with a solution for me ?

Thanks in advance!

Pierre.