Subject RE: [IBO] Huge performance differential
Author Support List
> 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)...

It seems as though something is not configured correctly.
IBO does need some knowledge and tuning to get the best performance.

Would you please provide me with more information?

How many records are in the dataset?
How many columns are in the dataset?

What is the FetchWholeRows property set to?
Are you doing a fetch all records?

Etc.

Thanks,
Jason LeRoy Wharton
www.ibobjects.com