The PanatrackerGP portal logs every transaction that is submitted to GP through the PanatrackerGP application. As you continue to use the application, your transaction history will grow. You may choose to periodically purge older transaction data from the PanatrackerGP database to improve the performance and manageability of the portal.
As with any database-dependent application, you should develop your own general strategy for archiving your data.
Attached to this article is an example script that we have created as a starting point for this data management task for the PanatrackerGP application. This script creates a procedure that moves older data from the PanatrackerGP transaction tables into new tables with a version-numbered suffix. The script should be run in the PanatrackerGP database to create the stored procedure.
The bottom of this script contains an example call to invoke this procedure once installed. It can be run periodically to move old data into the archive tables. Also consider creating a SQL job to perform this monthly if desired.
Support disclaimer: This script is provided as a suggested database maintenance task and should be run and supported only by a qualified database administrator. Please strongly consider backing up your database before running this script. It is provided as a courtesy and is not supported by Panatrack. We welcome any improvements to this script and procedure.
Our consulting resources can provide you with additional assistance if desired.
additional keywords: archive, purge