GAGEtrak Tip: How to Archive Calibration Records

GAGEtrak GAGEtrak Pro/Lite
,
1

Archiving older calibration records helps keep your database performant while preserving historical data for reference. Below are the recommended steps for using the GAGEtrak Archiver.

Steps to Archive Calibrations

  1. Open the GAGEtrak Archiver application.

  2. In the navigation panel, select Archive Records (located at the bottom).

  3. At the top of the panel, click Archive Calibration.

  4. In the Calibration Date section, set the To Date to the last date you want included in the archive.

    • You do not need to set a From Date—GAGEtrak will automatically use the earliest calibration date in the database.

  5. If you need to archive only a specific date range, you can also set From Time and To Time.

  6. Once your date is selected, click the Archive Calibration button at the bottom of the form.

  7. Allow the archiving process to complete. Depending on your total number of calibration records, this may take several hours.

This process safely moves older calibration data into an archive while keeping your active dataset lean for better performance.

2

I have looked at the Archiver tool and experimented a bit. I’m planning to dig into this topic soon to clean up our database. I have a quick question about access to the data. It appears that the tool saves to a second db file. Is this file not accessed when performing certain tasks? My goal is to decrease some time the program uses to, for example, acknowledge a calibration complete step.

1 Like
3

Howard,

That’s correct. Archived records are stored in a separate database, and it’s only accessed when you intentionally open archived data through the GAGEtrak Archiver app that installs alongside GAGEtrak.

Archiving older calibration records is known to improve overall system performance when a large number of records exist in the active calibration tables. That said, it’s not entirely clear whether archiving alone will have a direct impact on the time required to complete a calibration, as that process may be influenced by additional factors.

If you would like, the support network at CyberMetrics could help you take a look into speeding the system up (though you have to have an active MA), or at least pinpointing the cause of the system’s slowness.