Useful Links for Salesforce Data Skew Issue
If we have a very large number of contacts associated to the same account in Salesforce, Contacts Updates fail, Email-to-Case fails when the Salesforce has performance issues.
Type of Salesforce Data skew
- Account data skew
- Ownership skew
- Lookup Skew
What is Salesforce Data Skew? When have a very large number of child records associated to the same account in Salesforce then its called as Salesforce Data Skew, then how to overcome to Saelsforce Data Skew? Salesforce recommend that avoid to associating more than about 10k child records to a single parent record. for more details about Salesforce Data Skew – https://developer.salesforce.com/blogs/engineering/2012/04/avoid-account-data-skew-for-peak-performance.html
What is Salesforce Record Ownership Skew? When have a large number of records owned by a single user in Salesforce then its called as Salesforce Ownership Skew” – https://developer.salesforce.com/blogs/engineering/2012/06/architect-salesforce-record-ownership-skew-for-peak-performance-in-large-data-volume-environments.html
What is Salesforce Lookup Skew? When have a large number of records with the same object type are owned by a single use
Salesforce suggests to resolve the Salesforce Data Skew, Salesforce Record Ownership Skew issue and below are the useful Salesforce Articles:
Avoid Account Data Skew for Peak Performance – https://developer.salesforce.com/blogs/engineering/2012/04/avoid-account-data-skew-for-peak-performance.html
Architect Salesforce Record Ownership Skew for Peak Performance in Large Data Volume Environments – http://blogs.developerforce.com/engineering/2012/06/architect-salesforce-record-ownership-skew-for-peak-performance-in-large-data-volume-environments.html
Reducing Lock Contention by Avoiding Account Data Skew – http://blogs.developerforce.com/engineering/2013/01/reducing-lock-contention-by-avoiding-account-data-skews.html
Ownership Data Skew – https://developer.salesforce.com/docs/atlas.en-us.draes.meta/draes/draes_group_membership_data_skew.htm
