Here's the issue report after my forum post
Here's a very simple file, 29000 records of 4 fields (all fully indexed)
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