Close Tab and return to FTX lifeline Copyright ©2020 FastraxPOS, LLC.

Overview of Database Maintenance

Overview of Database Maintenance

After a period of time and depending on your chain size and store traffic, SQL databases can grow to a size which starts to affect computer/system performance.

For this, FasTraxPOS has built in maintenance tools to assist you in trimming down antiquated data.
Trimming this data frees up space as well as reduces the possibility of database errors while increasing efficiency.

Q: What does this maintenance do?

A: Several options are available to trim the size of the database and optimize all FasTrax software, specifically the POS, to increase speed and efficiency.
This also makes the database less prone to errors from maxed networking or computer resources.

Q: What does this exactly do to the database?

A: This will permanently delete data based on a date of your choosing going backwards. After completion, it will re-index (defragment) the database and shrink the DB size; freeing space on the computer!

Q: How often should I perform this maintenance?

A: We suggest at least once every 6 months. These can certainly be ran monthly or weekly if you choose.
Also, ensure no other POS/registers are being operated while this is performed, as it can be an intensive process.
A suggested time frame is after hours.

Q: On which machine(s) should this be performed?

A: This should only be performed on the machine that houses your database. This is usually register 1/main register.

Q: How much data should I leave in the database?

A: We suggest no more than a year of sales data to ensure a comfortable DB size.

Q: How do you get to the database maintenance tool?

A: Simply open Director, click the "Settings" hyperlink in the bottom right corner of the window, and select the "Maintenance" tab.

Q: Is this something FasTraxPOS Technical Support can assist me with?

A: Absolutely!
In fact, we would prefer you contact us the first time you attempt to ensure your understanding.

Q: What order should this be performed?

A: Follow the steps below for the absolute best results.