Has anyone come up with an effective way to archive older data from an app to a separate app on a regular basis to improve performance of the base app but still have the older data accessible to the user in the separate app almost like mirroring the app and using the mirrored app as a read only archive. The mirrored app could perhaps be a striped down version of the base app. This would be handy for large apps to improve performance by extracting or archiving older data. Would be interested in peoples comments.
One easy way is to create two apps and control the data amount with the security filter. Another way is moving the data from one gSheet to another gSheet with scripting.
In addition to @Aleksi’s suggestions, you might also be able to use table partitioning.