Jump to content
  • entry
  • comments
  • views

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



  • Create New...

Important Information

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