How to clean the pcAmerica database

Our goal here is to make your pcAmerica CRE or RPE run faster. After time you may notice your system running slow and sluggish. Do a manual backup of your database and check the file size. If it’s getting rather large (Over 1-2GB) you might want to try this.

Warning! NEVER erase your transactions without doing a backup of the database. You will lose all reporting. On the versions that I have done this on I have not lost any internal gift card balances. However I do recommend using an external card service like StoreCard.

Once you change the Database name on the master computer you will need to do any Slave machines as well. 

I recommend doing it this way because of the ease of switching back to the original database in case you need to run a report. No fumbling around looking for your backups. This is a good way of doing it say on January 1st and starting the year fresh.

Please remember to change the database name in the config file inside your auto backup folder. Hopefully you have taken 5 mins to set that up?

Leave a Reply

Your email address will not be published. Required fields are marked *

nine − 7 =