Vincent_L

Filemaker's ExecuteSQL GROUP BY is terribly Slow !

Discussion created by Vincent_L on Sep 16, 2015
Latest reply on May 11, 2016 by TSGal

Here's the issue report after my forum post

 

 

Hello,

 

Here's a very simple file, 29000 records of 4 fields (all fully indexed)

 

https://www.dropbox.com/s/qd9fldgj7bo6mid/slow_products_to_cat.zip?dl=0

 

The only think that solution does is

 

ExecuteSQL("SELECT Product_ERP from fast_products_to_cat GROUP BY Product_ERP";"";"")

 

My Macbook Pro Retina takes 4 minutes 50 seconds !

My 2010 Core i7 Macbook Pro : 7 min 48 seconds

 

This is pathetic. FMI should fix this, as well as many thinks in their FQL implementation which needs a complete rewrite imho).

 

P.S : This test solution is derived from actual use. Default log pass : Admin / blank

FMPa 14v2 Mac

 

 

Discussion here : https://community.filemaker.com/message/506834

Also reported there since FMS 12 : https://community.filemaker.com/message/506719

Outcomes