Try using transactions such as
(pseudo code).

BeginTransaction;
try
update ....;
Commit.
except
RollBack;
raise;
end;

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of pierre.ghislain
Sent: Friday, January 25, 2008 10:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] The Database file is growing exponentialy
with UPDATE query



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.






Bu e-mail'in tum icerigi gonderenin kisisel tasarrufu ile olusturulmus ve gonderilmistir. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. bu e-mail icerigi hakkinda sorumluluk kabul etmez.
This e-mail has been sent by the sender under his/her own individual discretion. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. accepts no responsibility.


[Non-text portions of this message have been removed]