Automatic Data Archiving: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The database can easily accomodate many millions of records but you may want to remove old data after a number of years. To make this process easy and automatic there is an Archive function which you can use to remove data which is older than x days. The archiving process runs as part of the background interfacing service. | The database can easily accomodate many millions of records but you may want to remove old data after a number of years. To make this process easy and automatic there is an Archive function which you can use to remove data which is older than x days. The archiving process runs as part of the background interfacing service. | ||
[[file:Archive_Admin.png| | [[file:Archive_Admin.png|link=|800px]] | ||
Care should be exercised when removing data from databases because there are complex relationships between tables and removing data from one table may effect how the system operates. | Care should be exercised when removing data from databases because there are complex relationships between tables and removing data from one table may effect how the system operates. | ||
Revision as of 11:49, 23 August 2024
The database can easily accomodate many millions of records but you may want to remove old data after a number of years. To make this process easy and automatic there is an Archive function which you can use to remove data which is older than x days. The archiving process runs as part of the background interfacing service.
Care should be exercised when removing data from databases because there are complex relationships between tables and removing data from one table may effect how the system operates.