If I would want to archive part of my database to lighten the server load (let’s say archiving pre-2017 data into another database for offline access only). What would the basic principle be for that as to ensure full database integrity and everything still working smoothly?
For the “archive version” would it essentially be to dump all tables and then simply delete ttrss_enrtries based the “update” field and keep all other tables “as is” ? And similarly for the active database, just delete older entries based on the “updated” date and still have a perfectly working system?
Would something like this be possible to “restore/merge” again at one point pending I’ve not touched all the existing relations for the data moved out or will Tiny clean some of that up (making it impossible)?
Setup: TTRSSv17.12 (1ddf3a2), Ubuntu 14.04.5 LTS, PHP 7.0.27, PostgreSQL 9.6.6, curl 7.35.0, 2000+ feeds.