Questions tagged [data-skew]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
34 views

Is lookup skew bad if it doesn't bring about row lock contention?

On Opportunity there are two lookups fields, the standard Primary Campaign Source, and a custom lookup to object Exhibition__c (which is set to Clear the value of this field if related record is ...
1
vote
1answer
24 views

Owner Data Skew Prevention for smaller orgs

We have a small org with ~50 users in the B2C space. Their business model includes importing large lists of records (~500 per day) and working on them. We can minimize lookup skew by not using lookup ...
1
vote
0answers
30 views

Lock_Row errors - Have you had to engineer fixes due to child record volumes? Data skew avoidance

I'd be interested to hear of any solutions people had to create to overcome a high dependency on parent Accounts. This article was written in 2012, so would be interested to hear of any updates to it, ...
0
votes
0answers
40 views

UNABLE_TO_LOCK_ROW Error on Unrelated Record

My organization utilizes two custom objects to track shipments for opportunities. Object1 represents a shipment, while Object2 is a parent object of Object1 which is essentially shares the same fields/...
0
votes
1answer
41 views

Best practice: Architecture for accounts with many locations 10k+

I'm facing an architectural design where a company could have more than 10k locations, and I would like to save the location data, according to this link it's a good practice to use a hierarchical ...
6
votes
1answer
1k views

Does Lookup Skew affect only master-detail relationships or also lookup ones?

I've been encountering and reading a lot about data skew issues, particularly lookup skew, and I've noticed that most information I've found doesn't explicitly indicate whether this affects master-...
3
votes
1answer
426 views

Will lookup skew be an issue on low-activity lookup on a high-activity table?

I'm wondering if it is safe to add a lookup that will have >50,000 children under a single parent. The child table has lots of inserts and lots of updates happening in parallel. However, the lookup ...
9
votes
2answers
3k views

The cause of UNABLE_TO_LOCK_ROW error?

My scenario is as followed, I have a single Parent account with about 600 child accounts. Every child account has a single Opportunity with 2 or more lines. I have a monthly batch job to create ...
0
votes
1answer
643 views

Parent - Child Records and Ownership/data Skew

I am aware of the concept of ownership skew (https://developer.salesforce.com/blogs/engineering/2012/06/architect-salesforce-record-ownership-skew-for-peak-performance-in-large-data-volume-...
2
votes
2answers
191 views

non-selective query error in sandbox

Is anyone else seeing an increase in non-selective query errors recently? I've been seeing them a lot over the past few weeks, in various instances, in places where they weren't happening before, ...
7
votes
2answers
177 views

Data skew error over 100k records for a managed packaged object

I know Data skew errors for Non-selective queries executed on custom field filters that are not marked as External throw this error, i.e. we cannot run SOQL on an object which has more than 100k ...