Questions tagged [ldv]
10
questions
5
votes
2
answers
1k
views
How do custom indexes impact performance negatively?
I am trying to understand the negative tradeoffs in creating more custom indexes on an sObject. Yes, they are helpful with query selectivity which speeds up reading data, but at what price. ...
- 10.5k
1
vote
1
answer
341
views
How indexes work when the WHERE clause contains AND
When we use AND condition in our SOQL query and lets assume both the fields are indexed and both are standard index.
eg) Select id from child__c where RecordType.Name = 'a' and parent__c ='...
- 11
15
votes
1
answer
1k
views
How to archive & restore Custom Objects in Big Objects
For my app I want to build a Archive and Restore functionality. For a given Custom Object MyObject__c and a Big Object ArchivedMyObject__b those requirements need to be fulfilled:
MyObject__c records ...
- 37.3k
10
votes
0
answers
469
views
Move Large Data Volume objects to Big Objects
I have built an Open-Source tool that collects App Errors in Managed Packages and creates Custom Object records for each of them in a Salesforce org. This app can produce thousands of records per day. ...
- 37.3k
2
votes
1
answer
327
views
how I use skinny tables in a sandbox
If I plan to use Skinny tables in my org, and say use it for accounts to improve performance issues, and as a result, set up say 30 fields in the skinny table, how do this work in the sandbox if ...
- 5,237
2
votes
1
answer
242
views
How update 120,000 Contacts which must be sorted in a specific order
As part of the Artisan Hub processing (global directory of Certified Salesforce Professionals) we need to run a daily process which assigns everyone a rank based on their total Artisan Hub points.
...
- 105
8
votes
0
answers
119
views
"Divisions" feature and query response times
From an LDV perspective, SFDC mentions Divisions are a way to speed up query response times:
Divisions... make searches, reports, and list views more meaningful to users in
very large organizations ...
- 2,191
2
votes
1
answer
124
views
Salesforce LDV SOQL cost based on null check
Question: Can anyone help me understand which is more expensive in batch apex query locator, given an opportunity record has 100 million records.
I have custom date (custome_date__c) field in ...
- 81
1
vote
1
answer
382
views
Rest API PATCH method with Large Data Volumes
Are there any best practices relating to the use of the Rest API within an environment with large data volumes?
I am aware of the SOQL best practices relating to LDV. Does this relate at all to ...
- 2,952
0
votes
0
answers
121
views
Is there a way to tell if custom indexes exist on an object?
I want to be able to design to use indexes and custom indexes where they exist.
Is there a way to tell if custom indexes have previously been created on a field?
- 2,952