[Emerald] Database Maintanence records

david leigh ( (no email) )
Fri, 26 Mar 1999 10:02:41 +0800

Hi All

We have seen hundreds of mails about database maintenance over recent days -
enough to point out that things are not clearly documented enough. May I now
formally request
"THE IDIOTS GUIDE TO DATABSE MAINTENANCE" be posted on this list with

Exactly what and when you are supposed to do things. This would be along the
lines of
a) Once a week you must run Update Calls. The current version of Update
Calls is (x size,date) and can be obtained from....
b) You should set a number of automatic procedures to do maintanence.
These are... and should run every...
c) When doing a Calls consolidate you should expect x time for x
records, and you should first do a .....


I *KNOW* that this information is covered in hundreds of fragmented places
throughout months of list posts, but I think the fact that it is still
generating such huge confusion should be a clear indication to post a very
detailed step by step guide to maintaining your dataabse.

David Leigh

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html