Improve List View Speed and Performance

List View Performance

• To determine the improved performance, it can be a trial and error process.  Each user might have different performance results as it also depends on many factors such as their role and visibility of records.
• List Views are designed for a snapshot view of current and important records which can be scanned and actioned by the user. From a usability perspective, our product managers have determined that the maximum number of records that should be handled in a single List View is 2000. Anything over that should be handled in a report.
• List View results are truncated at 2000 records, so the resource consumption accessing anything over this number is wasted. If it's known that the number of records being returned is more than 2000 then it's highly recommended to add selective filters to bring the number of records below that limit.
• The delay in loading of list views can also be caused if the user is having more number of permission sets assigned. We can create one permission set group and add all the required permission sets into it, assign that group to the user and the permission set which is of not in use should be removed.

Advanced Tips for Administrators
 

• A filter criteria can be tested by executing a similar SOQL query through Workbench. You can use the SOQL Query tool to quickly check how many records it would return for that particular filter set.
• If a List View returns fewer than 2000 records, yet still visibly takes time to load, then your System Administrator can ask Salesforce Support to possibly "Index" a filter on the database tables.
• If a list view returns more than 2000 records, filters must be added to reduce the number of records returned. 

Enhanced List views (Visualforce Page Optimization)

• If a Visualforce (VF) page has an Enhanced List View that's taking a long time to load, a Developer can modify the "listId" attribute to default the view to a specific one that is selective such as "TODAY."