0 Replies Latest reply on Dec 26, 2013 3:25 PM by SashaKay

    FMS13 xDBC performance issue with LIKE

    SashaKay

      Title

      FMS13 xDBC performance issue with LIKE

      Your post

           FileMaker Server 13.0.1 (Windows 7 Pro).

           The following query takes 1.2 secs to return 10 records from a table with 122K rows:

      SELECT FirstName,LastName FROM Contacts WHERE FirstName = 'Steve'

           The following query takes 22 seconds:

      SELECT FirstName,LastName FROM Contacts WHERE FirstName LIKE 'Steve%'

           The same search executes in less  than 2 secs in FQL (using ExecuteSQL), as well as FileMaker PHP API.

           Test were performed multiple times with 32- and 64-bit ODBC drivers (v13.0.12), as well as the latest JDBC driver. The results are always consistent.

           Has anyone else observed xDBC performance issues in FileMaker Server 13?

           Thanks!

           Sasha