Enable Auto-Archiving of Application Tables
212
Views
1
Comments
New
Backend

Many of our customers have the need to archiving and purging of data. 

The platform could have a toggle to turn the feature ON and it will automatically archive the data.

What could be done:

The platform could have an additional flag on Entities to allow archiving? If Yes, the platform will create an additional table with the same name with a prefix/suffix of Archive and also add IsArchived and LastUpdated columns to the Entities if not exist.

A timer could be scheduled to  allow moving the data from Primary and Archive tables. 

This could help customers who face performance problems in production and they will implement their own purging logic.

I have worked with many customers who did not think of Archive and Purge from Day 1 and when the application bloats, it is time consuming for them to implement this.

Changed the category to
Backend