Subject | The Database file is growing exponentialy with UPDATE query |
---|---|
Author | pierre.ghislain |
Post date | 2008-01-25T08:56Z |
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.
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.