Jump to content
Sign in to follow this  
  • entry
    1
  • comments
    2
  • views
    4,260

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

Sign in to follow this  
×
×
  • Create New...

Important Information

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