Cloud Kicks has 300,000 account records and 16 million invoices in a custom object with a master-detail relationship to the Account. Each account record takes a long time to display due to the rendering time of the invoice related list.
What should the consultant do to solve this issue?
Click on the arrows to vote for the correct answer
A. B. C. D.C
To solve the issue of slow rendering time for the invoice related list in Cloud Kicks, there are a few potential solutions to consider. Let's go through each answer choice and evaluate their suitability:
A. Move the invoice related list to a separate tab on the Lightning page: This solution suggests separating the invoice related list from the main account record page and placing it on a separate tab. By doing this, the account record page will load faster since it won't have to render the invoice related list immediately. Users can navigate to the separate tab when they specifically need to view the invoices. This solution helps improve the initial load time of the account record page, but it doesn't directly address the rendering time of the invoice related list.
B. Convert the Invoice object into a lookup relationship: This option suggests changing the master-detail relationship between the Account object and the Invoice object into a lookup relationship. In a master-detail relationship, the child object (Invoice) inherits sharing and security settings from the parent object (Account). However, this relationship can lead to slower rendering times when there are millions of child records. By converting it to a lookup relationship, the rendering performance might improve. However, this solution could have other implications, such as changes in sharing and security behavior, which should be carefully considered before implementing.
C. Enable indexing on all visible fields on the invoice related list: Enabling indexing on fields means that the database will create indexes to improve query performance. By enabling indexing on the visible fields within the invoice related list, Salesforce can optimize the retrieval and rendering of data. This solution directly addresses the performance issue by optimizing the data retrieval process. It is a recommended approach to improve rendering speed.
D. Enable Dynamic Related List for the invoice related list: Dynamic Related List is a feature in Salesforce that allows users to customize the related lists displayed on a record page. It enables users to add or remove related lists dynamically based on their preferences. While this feature provides flexibility to users, it doesn't directly address the rendering time of the invoice related list. Enabling Dynamic Related List may not be the most effective solution for improving performance in this case.
Considering the options, the most suitable solution for improving the rendering time of the invoice related list in Cloud Kicks would be:
C. Enable indexing on all visible fields on the invoice related list.
Enabling indexing will optimize the data retrieval process and improve the rendering performance of the related list. Additionally, it doesn't require major changes to the data model or user interface, making it a relatively straightforward solution to implement.