| Subject | Re: [firebird-support] Daily Maintenance Task for Firebird |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2003-09-08T12:51:10Z |
At 9/7/2003 09:45 PM (Sunday), Chooi-Ting wrote:
Firebird run well without the need for any daily admin tasks. I doubt if
the tasks you mention will help your server perform better. I would not
plan to perform any regular changes to the database beyond a backup. (Be
sure to restore from your backup to a test database to ensure it is
restorable.)
If your data changes over time you may want to review the statistics with
an eye toward re-building the indexes. That all depends on the actual data,
however. Many databases do not need this.
>Just want to check out what are the daily maintenance tasks needed toThe designers and developers of Firebird have taken great pains to have
>maintain firebird database.
Firebird run well without the need for any daily admin tasks. I doubt if
the tasks you mention will help your server perform better. I would not
plan to perform any regular changes to the database beyond a backup. (Be
sure to restore from your backup to a test database to ensure it is
restorable.)
If your data changes over time you may want to review the statistics with
an eye toward re-building the indexes. That all depends on the actual data,
however. Many databases do not need this.