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

    Filemaker's ExecuteSQL GROUP BY is terribly Slow !

    Vincent_L

      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