My administration -> logs page doesn’t load. I have 165,602,299 rows in that table. Does anyone else have this issue with size? Should I archive logs by month or quarter? Any advice would be appreciated.
I don’t believe the logs file has any pagination on it. Your browser will certainly crash before being able to load 165 million records. Typically for data retention policies to have frequent backups of your logs. For archiving purposes I would start archiving system logs once you start hitting 5-10 million records, whatever that may be for you (monthly or quarterly).
It would be best if we added pagination to the codebase for the logs as you will still time out the page on anything more than 100K entries. You can sponsor a developer to do that work or wait until someone in the community builds it for you.