If you use Chintaro Cloud, ignore this solution as Chintaro Support will perform all regular maintenance on your databases, as part of your licence agreement


To ensure that ChintaroSQL is performing to the best of its ability, it is your responsibility to perform regular maintenance on the database. If you do not use Chintaro Cloud, regular maintenance off the databases may be performed by your internal IT helpdesk, or it may be something you outsource to an external IT provider. 


Use this solution as a guide to what is required to ensure your databases are in optimum condition.


Performing maintenance on the RHP.mdw (Security Database)

RHP.mdw is the file that contains the security log in details for users.  As time goes by, this file increases in size. Like the RHMDAT.mdb, if this file gets too large (anything over 3000KB) Chintaro performance and speed can be comprimsed greatly. 


If the RHP.mdw database has become corrupt, users will receiving the following error:



RHP.mdw corruptions prevent all users from accessing the system.


Chintaro Support recommend running a Repair and Compact at least weekly (larger organisations with 15+ users should repair and compact the RHP.MDW daily), at a time when all users are all logged out of the system, for example, first thing on a Monday morning before users log in or last thing in the afternoon once everyone has logged out. For instructions on how to set up a Repair and Compact shortcut on your desktop, see this solution.


Updating the ChintaroSQL.mdb (Code Database/Version of Chintaro)

The ChintaroSQL client (ChintaroSQL.mdb) will usually be installed on the local drive (usually C:\) of each PC that runs Chintaro. This file holds the latest version of Chintaro and needs to be updated when users are advised there is a major release. Chintaro Support releases a new version on a monthly basis which can contain fixes for bugs, new features and enhancement requests generated by Chintaro users.


We suggest checking for updates on a monthly basis and then applying the update whilst all users are all logged out, for example, first thing on a Monday morning before users log in or the last thing in the afternoon once everyone has logged out. For instructions on how to update to the latest version of ChintaroSQL, please see this solution.


For further assistance with maintaining your databases

If you would like assistance updating your version of Chintaro or setting up the repair and compact shortcuts, please contact support@chintaro.com.au.