Skip to content

16) Large Data Volume Notes

Jump to bottom
Coding With The Force edited this page Jun 14, 2023 · 4 revisions

What Qualifies as LDV?

Typically anytime you see an object that will hit or exceed 1 million records it should be pointed out as an LDV object. Salesforce has a recommendation of no more than 50 million records per object, so when you see an object has or very likely will hit 50 million records you absolutely need to provide a way to offload/archive that data.

NOTE: If you have LDV on the Contact and/or Account object and those records are associated with an experience cloud user I would NOT suggest archiving them. Instead I would state that you would monitor them and look out for any account or ownership skew, and any performance slowdowns due to the large volume, and leverage custom indices and skinny tables to deal with any slowdowns should they occur. Archiving a contact related to a user is a dangerous road to go down unless it's absolutely mandatory.

Skinny Tables

Skinny tables are a mechanism you can deploy to speed up read only operations on tables with millions of records. For instance, if your contact object has 100 million records in it, and you notice that reports and list views are loading slower due to that volume, you can contact Salesforce support to setup a skinny table for your object to improve your performance in those read only areas.

There are drawbacks to skinny tables however, for instance, if you add a new field to your object and you add that to your list views, reports, etc, your skinny table will not be automatically updated to include that field, you must contact SF Support to have them manually add that new field to the skinny table.

Additionally Skinny Tables can only be used on the following objects:

  1. Account
  2. Contact
  3. Opportunity
  4. Lead
  5. Case
  6. Custom Objects

And skinny tables can only contain the following field types:

  1. Checkbox
  2. Date
  3. Date and time
  4. Email
  5. Number
  6. Percent
  7. Phone
  8. Picklist (multi-select)
  9. Text
  10. Text area
  11. Text area (long)
  12. URL

Custom Indexes

Account Skew

Owner Skew

Data Warehouses

Clone this wiki locally