How to optimize searching in large databases?

Dear mendix community,   I am working on a project to build a search filter. With this search filter, users should be able to search for objects in the database (300,000 objects). The search filter should consist of several open string fields, but it should also allow searching based on associations, where multiple objects can be selected.   I have built a test page where the open string fields are included in an XPath, and then list operations are used to further search based on the associations (When multiple objects are selected I loop over them). I find that this is currently a very slow process. Do you have any tips to make this faster?   Thank you in advance!
1 answers

Maybe you want to investigate using a Lucene based search option. See marketplace