What are people doing regarding growing database of old unused records from several years ago? It appears Sugar didn’t address this with some sort of function to archive all records older than x years old? Is everyone really just letting their number of database records grow indefinitely?

Database Archive Old Records Cleanup

pgr 14 November 2023 22:45 12

Contact Detail View takes long time to load when Cases subpanel is enabled - Works fine when hidden 💬 General Discussion

Here’s some more SQL scraps I had stored here somewhere, these will save you some time Delete orphaned records from contacts_cstm: SELECT * -- DELETE ChildTable FROM contacts_cstm ChildTable LEFT JOIN contacts ParentTable ON ChildTable.id_c = ParentTable.id WHERE ParentTable.id IS NULL Delete orphaned records from securitygroups_records: SELECT record_id, module, s.deleted, c.last_name, c.deleted -- DELETE FROM securitygroups_records s LEFT JOIN contacts c ON s.record_id = c.id WHE…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled