Subject | Very fast growing database file |
---|---|
Author | everixp |
Post date | 2002-11-12T12:04:35Z |
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.
Any idee ?
Regards,
Everix Peter
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.
Any idee ?
Regards,
Everix Peter