FMS13 xDBC performance issue with LIKE
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?