Hello All,
We know that Salesforce creates share objects when we set the OWD to Private or Public Read Only. When there is a huge volume of records, does the system perform faster when a user tries to search for a record or try to run a report if the OWD of the object is Public Read Only and slower when it is Private?
If the OWD were Private and I create one sharing rule to provide ReadWrite access to a group, there will be two entries in the share table - one for the record owner and one for the group with ReadWrite access.
If the OWD were Public Read Only and I create one sharing rule to provide ReadWrite access to a group, there will still be only two entries in the share table - one for the record owner and one for the group with ReadWrite access.
So, does it mean the performance will be same for Private OWD & Public Read Only and the it makes a difference only when we switch to Public Read Write OWD?
This is the reference documentation on record sharing under the hood and it only gives the example of Private OWD but does not talk about performance - https://developer.salesforce.com/docs/atlas.en-us.salesforce_record_access_under_the_hood.meta/salesforce_record_access_under_the_hood/uth_entity.htm
@Architects @Data Architects @* Salesforce Platform *
Thank you in advance and apologies for the long question.
But what about the users who should only read the records? If you do a private share and need to share for some users as read-only then you need those records in the sharing table. If you do read-only in OWD, then those records are not required. That’s where I see the difference.
