AnsweredAssumed Answered

Experience with executeSQL SELECT statements in FMPA 17?

Question asked by wxtyrs on May 23, 2018
Latest reply on May 24, 2018 by fmpdude

I do a lot of executeSQL() SELECT statements to lookup values across tables.


The tables contain 500k to > 1million records.


Anyone have experience with FMPA 17's performance with executeSQL() at this point?


I've not done systematic study at this point.  But FMP17 seems slower for now, than FMP16.


Comments - experiences??


Like many, the addition of SQL to FMPA has made it a much better platform.


I like the idea of a platform that combines techniques to allow a hybrid of approaches to solve a given problem: FMP native, javascript, SQL, etc.  The more open the better ...