Tech Docs: Maintenance
Maintaining Facil for Optimal Performance and Reliability
A database system like Facil puts much greater stress on the reliability of your computer and network then does most other computer software. The potential for damage or error in a database file is much higher. For example, a word processing document or spreadsheet file is held in memory while being edited and only written to once each time you save it; most such files are only read from and written to disk a few times in their entire life cycle. In contrast, the data file for a transactional database, like Facil, is written to every time new data is entered and saved; it may be written to many hundreds of times a day, day after day, for a lifetime of years. The fact that such a system can routinely run for months, or even years, without problems, is a tribute to the quality of PC software and hardware.
There are several things that you should do to insure the best performance and reliability from your Facil system. You should establish a regular schedule for each of these steps and insure that someone is responsible for performing them.
Preventing and Repairing Data Corruption
If the Facil data file is corrupted, the program may report that it can't find or validate the data file; it may give "unexpected error" messages when you attempt to use the data; or it may display obviously incorrect data, i.e. garbage characters.
The most common cause of data corruption is network errors due to bad wiring or failing network components, such as network interface cards or network hubs. Another possible cause is a computer that crashes or is powered off while running Facil. To protect against corrupted data, be sure your network is functioning reliably and always maintain a current backup of Facil data.
The Facil Data File Maintenance function will repair most cases of data corruption and, when used regularly, also helps to protect against future corruption problems. If the Data File Maintenance fails to resolve the problem, contact Tech Support at Becker Software, email to [email protected] or call (520) 991-0909.
|Facil Data Management Software for Media Access Centers||Facil Home Page Becker Software Home Page|
|All Material Copyright © 1999-2010, Becker Software, Tucson, Arizona||This Page Updated 05/26/2010|