Subject Re: [ib-support] Very fast growing database file
Author Svein Erling Tysvaer
Everix,

30Mb is a very small database to be Firebird, so this is not your problem.
And FB never releases any disk space, just reuses it when necessary, so it
is no surprise that it shrinks like this following a restore. You do not
say which version of FB you are using or which components you use in Delphi
- which could be useful to know.

As a wild guess, do you have any long running transactions? What about
indexes? And how slow is 'very slow'?

You must probably tell us a lot more for us to help you find the solution
to your problem,
Set

At 12:04 12.11.2002 +0000, you wrote:
>Hello all,
>
>We are developing a program using FireBird and Delphi 5 which
>register every 5 minutes a couple of temperatures.
>The program is working well but at a given moment, the access to the
>database became very slow and the hard disk of the server does a lot
>of activity.
>
>When looking to the database file, we noticed that the file was
>growed from appr. 8Mb to 30Mb and after this the database is very
>slow.
>When we backup and restore the database, it is back the size of appr.
>8Mb.