We recently migrated our codebase from FIBPlus to IBDAC and we are experiencing very significant downgrades in query execution performance. Especially using an IBCQuery.Open with the same query repeatedly.
Here is the case:
- Server: Firebird 2.5.5
Connection: Remote over local network.
Components compared: IBCQuery configured with its defaults vs TpFIBDataset under the same conditions.
Query: Simple select of a table with 5 records.
Execution: Count= 100. Connection is ACTIVE throughout the loop. The Query is not reset before each execution.
IDBAC AVG Time: 668 MS
FIBPlus AVG Time: 212 MS
I read in another Post that turning off the option QueryRowsAffected helped, and it did but we aren't quite there yet:
What else can we do to optimize this? We really need to get back to our FIBPlus execution times as soon as possible.
Thanks in advance.