Data Repeater Performace

Unknown

Data Repeater Performace

Unknown

I have a project that I’m trying to improve performance on.

The process I’m specifically trying to improve
[ul][li]reads data from an excel sheet,[/li][li]uses that data to create a list of entities, and[/li][li]loads that list into a data repeater on a form.[/li][/ul]

Currently, it takes about 2 ½ minutes for the form to load 250 records. I tested with a blank form and data repeater without any rules or data flows, and that loaded in about 20 seconds. What steps can I take to minimize load time?

Unknown

[b]Any Validation Rules, Data Flows, and Visibility Rules in the source control of your Data Repeater will compound the load time of a Data Repeater.[/b]
[b]
[/b]
More complexity directly correlates to a longer load time with this component, as everything that will run for one of the items in a list has to run for all of them. Larger lists also correlate to longer load times, as it increases the number of times everything in the source control has to execute.

Consider this case: If you have Data Flow with a complex SQL query or an API call - the execution time of each query or API call is multiplied by the number of items in the list mapped into your Data Repeater and added to the forms load time without that Data Flow. IF the data requires these operations, and will always be a large dataset, then a Form with a Data Repeater is not the right tool for the job. It will always be faster to have a [url=https://documentation.decisions.com/docs/using-flow-source-report]Flow-Sourced Report[/url] that is cached (optional) to do something like this.