Index in the Mendix application with Postgre SQL

0
Hi, We have planned to fussy logic in one of the search process and it will have millions record in that table with more than 5 search fields. Is it feasible to use fuzzy logic in mendix for the postgresql using Index. or Is it good to use MySQL or Oracle? Any suggesttions appreciated Thanks in advance!!! Prakash  
asked
2 answers
1

You can implement lucene , however the full fuzzy search from lucene is not implemented yet.

answered
0

Hi Prakash,

If, by "fussy logic", you mean search fields that search on a part of a string (contains), the database will not use any idexes that you added through the model.

Regards,

Hans

answered