LDV performance mitigation strategies
There are several tools available to us as data architects when it comes to working with data and keeping things running as optimally as possible. Of course, we should first question what data needs to reside in Salesforce. How often should we consider moving data off-platform to reduce performance impacts due to having large amounts of data available? Typically, data of a certain age (determined by business requirements or regulatory requirements in some instances) should be archived regularly to ensure that users are only interacting with the data that makes sense to be hosted on the Salesforce platform.
With data that may need to reside on Salesforce, some other techniques are available that can improve performance:
- Custom indexes
- Skinny tables
- Selective filter conditions
- Divisions
Let’s take a look at them.
Custom indexes
To speed up query performance, Salesforce supports the creation of custom indexes...