At 07:56 PM 25/01/2008, you wrote:

>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.

What "Interbase driver"? Do you mean the InterBase driver for the BDE?

>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 ?

You must come up with a solution yourself, by writing application code that makes hard commits in a timely manner. It is important, therefore, that you describe the workflow of this application: how you start a transaction, how you execute a statement, how you finish a transaction.

Perhaps, first, you could describe for us your understanding of how Firebird's multiple-row-version concurrency mechanism works...

./heLen