Preload data in a search grid to avoid multiple select calls to the database
We're using the TextBoxSuggestion widget to autocomplete certain search criteria. as of now the widget uses either xpath or microflows to fetch data every time a character is pressed. Which means if i search for "What is my insurance?", mendix will execute 21 select statements. is there a way to pre-load the data based on the associations in the search grid? so that mendix doesnt do multiple selects?