Limit data in the App and archive old data automatically
Hi, The licensed Mendix app is storing huge data, so the query performance is very slow. So we decided to limit the data in the App to say 1 year. The data before that has be archived automatically by the app. Archive is logically different from backup and I don’t see any topics on archive in Mendix docs. Please suggest the approach that should be taken to limit the data in the app and automatic archive mechanism.
It would be so nice if Mendix started to support the table partioning possibilities of Postgres. But till then you have to create it yourself by duplicating the entities and moving the object from the source entity to the archive entity. But searching will be complicated because you should look in two different tables.