Automatic Data Archiving - Revision history

Dgarratt: Updated by push_wiki.py

2026-04-01T10:09:27Z

Updated by push_wiki.py

@@ Line 1: / Line 1: @@
-[[Category: Commander4j]]
+Commander4j's database can comfortably hold many millions of records, but after several years of operation you may wish to remove old data to keep the database size manageable and query performance fast. The Archive module allows you to define automatic data deletion jobs that run on a schedule as part of the background interface service.
-[[file:Archive_Admin.png|link=|800px]]
+{{Note|Care must be taken when removing data from the database. Commander4j's tables have complex relationships between them. Deleting records from one table may affect the behaviour of related features. Always back up your database before enabling new archive jobs, and test any new job with a small retention period on a non-production system first.}}
-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.
+== How Archiving Works ==

Dgarratt at 09:28, 25 August 2024

2024-08-25T09:28:59Z

← Older revision		Revision as of 11:28, 25 August 2024
Line 1:		Line 1:
			[[Category: Commander4j]]
	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.

Dgarratt at 10:49, 23 August 2024

2024-08-23T10:49:23Z

← Older revision		Revision as of 12:49, 23 August 2024
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\|~~700px~~]]		[[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.

Dgarratt at 09:36, 22 August 2024

2024-08-22T09:36:24Z

← Older revision		Revision as of 11:36, 22 August 2024
Line 2:		Line 2:

	[[file:Archive_Admin.png\|700px]]		[[file:Archive_Admin.png\|700px]]

			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.

Dgarratt: Created page with "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. 700px"

2024-08-20T09:20:57Z

Created page with "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. 700px"

New page

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|700px]]