By User on Friday, 26 February 2021
Posted in General Issues
Replies 1
Likes 0
Views 346
Votes 0
Hello. In backend I turned OFF "Enable Privacy".

Can I now clear #_social_privacy_items
It's 647 959 lines (63.2 Mb).

Can I also erase #_social_privacy_map?

What about #_social_privacy?

Nothing will be broken?

Thanks.
To be honest, I wouldn't recommend removing the data from these privacy tables is because the system only uses this setting "Enable Privacy" to determine that whether need to check the user privacy before rendering the item.

In other words, if this setting is disabled then the system can retrieve the data will be fast if compare when you enable the privacy setting is because from the SQL query wise, it doesn't need to check for the user privacy when executing the SQL query on the server.

Just for your information, even you disable the "Enable Privacy" setting, it will still generate the user custom field or other item data into these tables is because the system also needs to handle this what if the site owner decides to re-enabled back privacy in one day.
·
Friday, 26 February 2021 11:19
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post