Achieve optimum performance with your filters when you follow best practice.
To achieve optimum performance and reduce the time it takes a module to load:
- Evaluate your filters to see if they still produce meaningful results. Remove any filter that is no longer useful.
- Do not filter line items with a line item summary. A numeric filter on 10,000,000 items can take less than a second, but a summary takes at least 5 seconds.
- Limit the filters applied to nested dimensions on rows. The nested filter is slower on the same number of items compared to a flat list. A filter applied to a 10 by 1,000,000 nested dimension compared to a 10,000,000 item list is 40% slower.
- Use a single Boolean filter on a line item that does not have time or versions applied and does not have a summary. This enables you to reuse the line item and combine a series of Boolean line items into a single Boolean to use in a filter. This increases speed.
- Check the saved view open time to see the impact on the import performance and adjust the filter if possible. Filter duration affects saved views used in imports.
- If you need to repeatedly filter for specific list items, create a subset of list items and then a new module to view a set of data.