Cloud Kicks has 300,000 account records and 16 million invoices in a custom object with...

With Cloud Kicks having a large number of Account records and a substantial volume of Invoice records linked via a master-detail relationship, page load performance can be affected when a large related list is displayed. Moving the Invoice related list to a separate tab on the Account record page can help alleviate this issue by reducing the initial data load required when viewing the Account record.

Optimizing Page Layouts for Performance: By placing the related list on a separate tab, Salesforce loads the tab’s contents only when accessed, rather than at the initial page load. This can significantly improve page performance, especially with large data volumes.

User Experience and Adoption: Communicating this change ensures that users understand where to find the Invoice information while benefiting from faster page load times.

Option A (converting to a lookup relationship) could alter the data model and existing functionality, and Option C (indexing) may not address initial page load performance directly. Salesforce recommends using custom page layouts and tabs to manage large related lists as part of performance optimization best practices, detailed in Salesforce Large Data Volume Considerations.