Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#187 - Safe Table Maintenance
My securitygroups_records table is getting very large (over 1.2 millions records). How do I safely delete some of this data?
-
"Works only EN lang, If run upgrade SecSuite under RU lang - error..." - vstgod
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
10 years ago
+-------------------+----------+ | module | count(*) | +-------------------+----------+ | ProjectTask | 5 | | Accounts | 4043 | | Project | 5 | | Documents | 44 | | csg_Merchants | 1 | | Users | 17 | | Bugs | 78 | | Releases | 4 | | SavedSearch | 1 | | UserPreferences | 157 | | Notes | 461 | | SugarFeed | 9943 | | Campaigns | 84 | | Import | 10556 | | SecurityGroups | 10 | | DocumentRevisions | 6 | | Meetings | 218 | | Contacts | 329 | | Cases | 3182 | | Employees | 3 | | ACLRoles | 6 | | Emails | 4774 | | DynamicFields | 3 | | Schedulers | 3 | | SchedulersJobs | 1208194 | | Leads | 34995 | | ProspectLists | 59 | | Tasks | 63 | | InboundEmail | 6 | | Prospects | 8103 | | ACLActions | 24 | | Administration | 4 | | Opportunities | 5 | | vCals | 3 | | Calls | 41 | | EmailMarketing | 45 | | EmailTemplates | 29 | | CampaignLog | 801 | | CampaignTrackers | 43 | +-------------------+----------+
10 years ago
That's the SchedulersJobs table with 1.2 million records. That should be safe to purge. If your securitygroups_records table ever does get large you can delete those that are set to deleted = 1.
9 years ago
It was found that SchedulersJobs did cause the securitygroups_records table to inflate dramatically. This was fixed as of 2.7.2.
-Jason