System Takes Too Much Time To Display Search Results in an Auto Complete
I have an Auto Complete which is being sourced from a Data Page (Integration). The number of records being retrieved from service are more than 10000. While entering the values the system takes more than a minute to show the search results. How can the search time be minimised?
***Edited by moderator, Maryrita: moved to Product Support from Applications***
Hi Mahesh, TIme taken is not an issue. However Pega runs a When rule "pzACRowVisibleWhen" for each letter in the string that is typed in the AutoComplete to fetch the records matching the string. In my Case we already have 10000+ records and so when something like "ABCD" is type, pega first searches all the records starting with A, then again all the records starting with AB and so on... This whole process is causing the delay. Is there anything we can do other than creating custom controls with custom java search code??
In order to overcome this issue from Pega 7.3+ onwards we have the feature to display the results in a list as shown in the attachment. Here "In a table" means it will use grid in the results and "In a list" option will use ul/li structure to improve the performance.
If you are using "In a list" results display then the results matching will happen at the client side based on ul/li structure to improve the performance of the search.
We are using an autocomplete with "In a list" feature. But while we are selecting the values from autocomplete the system is choosing the next value of the selected value . i.e., if i have say 1 ,2 ,3 . On run time if i select value 1 autocomplete is picking 2 and showing 2 on screen as well as in clipboard . Have you faced any similar problem ? i am using 7.3.1v