What are the large data volume (LDV) patterns and best practices?

LDV patterns for orgs with millions of records:

1. Defer sharing calculations: During bulk data loads, defer sharing rule recalculation to avoid lock contention.
2. Avoid record locking: Minimise the number of records being locked simultaneously.
3. Use External IDs: For upsert operations in integrations.
4. Batch Apex with skinny tables: Avoid queries with complex JOINs.
5. Selective queries: Always filter on indexed fields.
6. Avoid lookup cascade: Large numbers of related records can slow down parent record saves.
7. Archive old data: Use BigObjects for long-term storage; query current data stays performant.
8. Avoid cross-object formula fields on large objects — they prevent indexing of related fields.
9. Parallel data loads: Split large imports into parallel Data Loader jobs.