Subject | FB Database gets slow and grow up to much with the time passed.. |
---|---|
Author | adrian_avila_mtz |
Post date | 2005-06-04T17:57:14Z |
We have an application that work w/o interruptions with Firebird 1.52,
the Database process transacctions 24/7, after some days the
transaccions get slower and the Database grows to much (in a period of
1 to 2 weeks)
The solutions we take are:
1.- Reset the server
2.- Backup and restore the database (after that the side of the
database shrinks a lot)
My question is why do this ocurrs?
and what could it be the solution?
The application MUST NOT STOP, so, how can we purge the dabase w/o
shut it down or avoid the problems explained?
Thx.
the Database process transacctions 24/7, after some days the
transaccions get slower and the Database grows to much (in a period of
1 to 2 weeks)
The solutions we take are:
1.- Reset the server
2.- Backup and restore the database (after that the side of the
database shrinks a lot)
My question is why do this ocurrs?
and what could it be the solution?
The application MUST NOT STOP, so, how can we purge the dabase w/o
shut it down or avoid the problems explained?
Thx.