Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Duplicate records in securitygroups_records

Duplicate records in securitygroups_records 4 months 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 4 months 1 week ago #82067

  • AlxGr
  • AlxGr's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 325
  • Thank you received: 58
  • Karma: 11
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/
I can help you with your customization. Requests at ctmprograATondsystemsDOTcom
No dude en contactarme si necesita personalizar su aplicación. Mi email es ctmprograARROBAondsystemsPUNTOcom
The administrator has disabled public write access.
Time to create page: 0.051 seconds
Powered by Kunena Forum