AnsweredAssumed Answered

FMS13 xDBC performance issue with LIKE

Question asked by SashaKay on Dec 26, 2013

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 

      

Outcomes