Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Duplicate records in securitygroups_records

Duplicate records in securitygroups_records 1 month 1 week ago #80290

  • datcman
  • datcman's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 0
Hi, in the heritage I got a big project on this engine. After analyzing it, I was horrified. Table securitygroups_records takes, attention, 98GB !!!
Looking deeper, I noticed that every time a record is saved in any modules / SecurityGroups / SecurityGroup :: inherit_assigned () module adds an entry to this table. I found a huge number of identical records.

I think the fact is that inherit_assigned only checks for the presence of assigned_user_id in focused Bean.

Your opinion is important to me: is this the correct behavior conceived by the developers, or is it a bug?

Thank you in advance!

Suite Version: 7.6.4
Sugar version:
{
"sugar_version": "6.5.23",
"sugar_db_version": "6.5.23",
"sugar_flavor": "CE",
"sugar_build": "1061",
"sugar_timestamp": "2015-10-16 04:48pm"
}


ps: Sorry for mistakes, google translate )
The administrator has disabled public write access.

Duplicate records in securitygroups_records 1 month 1 week ago #82067

  • AlxGr
  • AlxGr's Avatar
  • Online
  • Elite Member
  • Posts: 186
  • Thank you received: 30
  • Karma: 5
Any DB will require maintenance eventually. SuiteCRM doesn't delete records. They are flagged only.

Take a look to this blog:

https://pgorod.github.io/Database-tables-size/
The administrator has disabled public write access.
Time to create page: 0.035 seconds
Powered by Kunena Forum