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?

Hi Jeff SuiteCRM soft deletes the records which means they are Marked as deleted but still stay in the Database for One Month. Their is a Scheduler Job “Prune Database on 1st of Month” which runs every month and cleans up those soft deleted record to clear up the DB. Make sure your cron jobs are r…

what cherub-chum said is true, but that scheduler is disabled by default, you need to enable it best regards

You are talking about permanently deleting DELETED records. To go through and try to delete THOUSANDS of old records via the user interface is too difficult. I’m talking about a function that AFTER pruning deleted records, goes through select tables, like cases, tasks, invoices, emails, notes, etc…

I found this great thread here and I wondered something similar. Is there a kind of ‘database maintainer’s guide’ somewhere? Or some kind of ‘best practices’ for SuiteCRM? This would be great. My only plan after reading this is to: take a DB backup Start the ‘prune’ job (by the way - do I have…

I’m just replying to my own post here because I think there is some big benefit. What I was searching for ‘may’ be including in this page. I’m not sure but I suspect the forum user who made this is @pgr ? Yes, indeed it was pgr Although I’m still super inexperienced, I think I will start working…

Please have a look at this tool for Automation of backup and restore. https://store.outrightcrm.com/product/suitecrm-backup-restore-manager/

How did it all go? I checked PGRs article, and ran the query in PhPMyAdmin… Not sure what to do with the information I got from the query. My workflows in SuiteCRM are working but Perform Lucene Index, and AOD are failing at the moment… My Uploads folder is 9GB or so I may be in need of some ma…

@dwaynecasey I’m pretty sure your Lucene Index and AOD optimization are failing are because of memory allocation for the PHP version in WHM OR allowed_cron_users. Unless you have a lot of workflows that run all the time on every record, you won’t have a lot to clean up in the workflows. Cleanup of…

For the uploads folder, there are articles in my blog which will probably help you. How are Attachments stored? At some point you might need to go under the hood and see how SuiteCRM stores Attachments in the database, and in the file system. So here’s a guide to help you out. If have…

pgr wrote in his blog: Orphan records in relationships … You can hunt down these rows with clever SQL. Does anyone of any examples of these clever SQL Queries?

SuiteCRM

Database Archive Old Records Cleanup

💬 General Discussion

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