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?
-
"We have big problem with SuiteCRM v.7.3.1 when creating custom screen by group. The Dashlets on the start page disappear for all user, we have this pr..." - claude_f.
Read More Reviews
12 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 | +-------------------+----------+
12 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.
11 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