Difference between revisions of "9. Purge Data"
From TrueERP wiki
Cgillhouse (Talk | contribs) (Created page with "'''Purged Data''' '''Purged Data - Where would you find the purged Audit Trail Folder?'''") |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'''Purged Data''' | '''Purged Data''' | ||
| + | |||
| + | Database administrators purge data from tables when the table rows exceed several hundreds or even millions of records that are no longer needed. However, purging lets you archive the records even though you remove them from tables. Administrators move records from a large table to an archive table. Purging records from a large table speeds up queries. | ||
| + | |||
'''Purged Data - Where would you find the purged Audit Trail Folder?''' | '''Purged Data - Where would you find the purged Audit Trail Folder?''' | ||
| + | |||
| + | When '''Purging Data''', you will be prompted to name and set a destination for the exported file copy. | ||
| + | |||
| + | |||
| + | '''Purging the Audit Trail''' | ||
| + | *Select Utilities Drop Down menu | ||
| + | *Select Audit Trail | ||
| + | *Select Purge Audit Trail | ||
| + | *Enter name of file to archive the records before purging | ||
| + | *Select OK | ||
| + | |||
| + | |||
| + | Purging the audit trail does not lose the data. It is important to purge the Audit Trail on a regular basis as it will otherwise slow ERP as the file grows. | ||
Latest revision as of 09:47, 9 October 2015
Purged Data
Database administrators purge data from tables when the table rows exceed several hundreds or even millions of records that are no longer needed. However, purging lets you archive the records even though you remove them from tables. Administrators move records from a large table to an archive table. Purging records from a large table speeds up queries.
Purged Data - Where would you find the purged Audit Trail Folder?
When Purging Data, you will be prompted to name and set a destination for the exported file copy.
Purging the Audit Trail
- Select Utilities Drop Down menu
- Select Audit Trail
- Select Purge Audit Trail
- Enter name of file to archive the records before purging
- Select OK
Purging the audit trail does not lose the data. It is important to purge the Audit Trail on a regular basis as it will otherwise slow ERP as the file grows.
