Ideas to optimize search functionality which has about 15 filters.

0
Ideas to optimize search functionality which has about 15 filters which include 5 dropdowns and 5 reference selectors and dates and text boxes. Based on these selections on clicking of search button we fetch the data from multiple tables and associations and search on them and provide results. Because this process is very time consuming and heavy our web application is crashing. I want some ideas and tips to optimize the search functionality.
asked
3 answers
1

Hi Vineeth,

Did you consider, using the OQL Module?

By using OQL, you can make your filtration process many times faster and efficient,

 

Let me know, if you have any issues,

Hope it helps!

Rishabh

(Resilient It Services)

answered
0

One idea is to use Indexes 

 

https://docs.mendix.com/refguide/indexes/#1-introduction

answered
0

We have an application that needs to search fast as well, and we ended up having to denormalize the data so that there were no joins. We had fields with jsonified lists of objects stored in a string, and then used a java action to cast the list of json objects back into a string and query them.

 

To cast the list of json objects into a string, we used this query, "left join json_array_elements(CAST(attribute as json)) attribute on true"

answered