| Subject | Re: [firebird-support] Concerns about Firebird database to get perform with less downtime. |
|---|---|
| Author | Ann Harrison |
| Post date | 2018-11-13T16:52:01Z |
On Nov 13, 2018, at 7:22 AM, Marcelo Guimaraes mfguimaraes@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
Mark,I understood your explanation, but here where I work, the people don't do any maintenance on the database, such as sweep (they turn it off for default) and index stats. To avoid that, on the end of the day, they turn off the application and execute backup and restore.I would like to change this culture, but I need to know what to do. Like I told, I just know that I have to execute de sweep and collect index stats, but what more?
Make friends with gstat which will tell you a lot about the health of your database. Look for index depths, old version chains, page fill levels and more.
Good luck,
Ann
Rega