Support Article

Autocomplete performance slow sourced from 11k items

SA-36312

Summary



There are performance issues for an Autocomplete control sourced from a data page with 11,000 items. It is slow to return results and, sporadically, the wrong result is displayed during performance degradation.


Error Messages



Not Applicable


Steps to Reproduce

  1. Add an Autocomplete control with a data page containing 11,000 entries.
  2. Type and delete characters and see how the behavior of the control gets slower and slower.


Root Cause



An issue in the custom application code or rules
The Autocompete control is not suited to such large data sets.

Resolution



Perform the following local-change:

When you have a data set this large, the best way to handle it is to use parameterized data pages to filter the results so that there is only a subset of the data sourcing the Autocomplete. Below is an example configuration.

1. Specify a Report Definition to be used as the source of the data page.
This allows you to configure a filter condition based on a parameter value as shown.
Define the parameter in the Parameters tab.
The highlighted section of the example below, Edit filters, shows how to make the filter case insensitive if this is a requirement.

Conditionalized Report Definition for Autocomplete data source

2. Specify the data page to use the parameter.

Specify data page parameter


Edit data page definition to pass parameter


3. Specify the Autocomplete to use the parameterized data page:
Select the check box “Search using data page parameter”, which appears when you specify a parameterized data page.

Edit Autocomplete to use parameter from data page

4. Test the Autocomplete control.

Example test results of Autocomplete control

Published April 11, 2017 - Updated August 2, 2017


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.