Subject Huge performance differential
Author jlane_campbell
I've recently run a test within the Delphi 2010 framework, comparing IBObjects performance with Delphi's dbExpress connection. On a common form, I placed two DevEx cxGrids. One grid was linked to a TIBOQuery connected to a Firebird DB via a TIBODatabase component. The other grid is linked to a TSimpleDataset that connects to the same database via the TSQLConnector object. Both queries are the same (select * from constituents order by constituentid). The dbExpress component chain loads its grid in about 2 seconds. The IBObjects component chain is taking upwards of 20-30 seconds. In both cases, the query produces 16,223 records in the result set.

Our 2010 installation is IBObjects v4.9.12; the DevEx grids are from the Quantum Grid Suite v6.55

What's happening? What's causing the huge performance hit?

I'm noting that the dbExpress chain is allocating about 14Mb of memory in returning the result set ... the IBO chain has little or no affect on memory usage ...

Any answers, pointers, tips greatly appreciated, as we've got a history of highly satisfactory use of IBObjects with Delphi 7 (although with a similar performance hit loading DevEx grids from TIBOQuery)...

Lane Campbell
NW Software