Housekeeping process
The housekeeping process ensures that RefTracker runs optimally. Therefore there are no parameters for the Housekeeping process that you can change.
In order to keep the housekeeping runs short they run every 4 hours, and if the housekeeping hasn’t been run within the last 4 hours, it will run whenever a full user logs on (which should only happen if the background process is not running for some reason).
The Housekeeping routine:
- removes old log files
- removes temporary files and tables
- removes expired operational items
- Re-indexes the full text indexes for the relevant RefTracker tables (Question, Client, Bib, ILL, QuickText clauses, Notes, and Mail messages) in order to improve searching response times, and prevent fragmentation. The re-indexing routine will only run between 10pm and 8 am for the default staff location, and only if fragmentation of a table is greater the 10%.
- updates the Filestream attachment content searching full text indexes based on the file type information in the Attachment snapshot table (viewable at System>Utilities>Information>Attachment snapshot) and the amount of time since the file was uploaded – if the customer is licenced for the Attachment Content Searching module.
The system checks to see if the database backups are imminent and will not perform some Housekeeping processes if the run is likely to happen at the same time as the intense backup activity.
Your RefTracker system application pool will also be recycled on a regular basis (usually every 24 hours).
Application pool recycling:
- ensures that any memory issues are resolved by restarting the application
- allows functions that are detected as configuration changes to occur – such as deletion of the attachment/view directory to clear out attachment viewing temporary files