Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×
  • entry
    1
  • comments
    2
  • views
    4,932

About this blog

FM tips and tricks I never found myself

Entries in this blog

FM and MySQL Views - let MySQL do the dirty work beforehand

How I got a list with data from MySQL in less than 1 second with a SQL VIEW - from an awful 20-25 seconds when going through relationships between multiple tables from the MySQL database. My Filemaker solution is integrated with a MySQL database that has been highly normalized for different reasons. This means that a simple list with 4 different fields can easily contain info from 4 different tables, where a couple of the relationships might span 3 tables. This made the performance in FM
ah

ah

2
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept