8 Replies Latest reply on May 11, 2016 6:01 AM by TSGal

    Filemaker's ExecuteSQL GROUP BY is terribly Slow !


      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