We are looking at moving data from a couple of FMP tables to MySQL, while keeping FM as the GUI. So far, everything is fine, and performance is good... except for one place. One of the layouts is using calculation fields to make it easier to search multiple fields from the same text box. Example:
adresseligne1 & " " & adresseligne2 & " " & adresseligne3 & " " & adresse_secondaire_ligne1 & " " & adresse_secondaire_ligne2 & " " & adresse_secondaire_ligne3
When we use those for search, FileMaker is fetching *all* data from the MySQL table, and since we have over 450 000 records, it takes a long time. If we use regular fields, everything is fast. But that would require to add many fields to the search layout.