-
What is Data Skew in SFDC?
What is Data Skew in SFDC?
-
2 Replies
-
Hi Saddam,
Certain Salesforce objects, such as accounts and opportunities, have special data relationships that maintain parent and child record access under private sharing models. If too many child records are associated with same parent object in one of these relationships, this imbalance causes something called “data skew,” which in turn causes performance problems.
Thanks.
-
Data skew can kill performance of your org
The majority of Salesforce customers will never suffer performance issues in their orgs. However, there are certain configuration patterns which appear again and again, because they are apparently “good ideas”, but which increase the probability of performance issues arising in our Org. These patterns cause inefficient data distributions at the storage layer, technically known as Data Skew. Data Skew problems and are so hard to anticipate and can have such a dramatic impact on performance that they are known by Salesforce as “the silent killer”.Perhaps the most common of these patterns is when a single user owns more than 10,000 records of an object. This type of skew is called ownership data skew. In most cases, the customer will not notice any issue even when having this kind of a situation, but there is one particular situation in which the impact on performance of this kind of Data Skew can be very significant.
Log In to reply.
Popular Salesforce Blogs
Top 12 Salesforce Winter ’19 Features
It’s been a busy month for Salesforce. With the most awaited, world’s greatest tech conference, Dreamforce 2018 unveiling today and the launch of Winter ’19 Release, we are…
What is a Salesforce AppExchange App - Here's All You Need to Know
A marketplace called AppExchange provides products including software, parts, and consulting services. Salesforce AppExchange App is a platform that mainly improves a company's business process.…
How to Simplify Ideas Management in Salesforce
It goes without saying that having a system in place for collecting and evaluating recommendations for your strategic goals is a good idea. And gathering,…
Popular Salesforce Videos
14 Questions Asked in 95% Salesforce Interviews
In this video, Dan Croitor provides a list of 14 questions that are typically asked in Salesforce interviews. He goes over each question in detail,…
How to Use Salesforce Process Builder 2017
Salesforce process builder is a powerful tool you can use to automate business processes. It has a simple interface that allows you to point and…
Salesforce: How To Set Up Einstein Bot
With Einstein Bots, you can keep your service reps free from simple, repetitive tasks and they can spend more time on complex customer cases. If…
