Subject Re: [IBO] Huge performance differential
Author jlane_campbell
--- In, "Support List" <supportlist@...> wrote:
> > 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)...
> Also, would you please get the latest release IBO 4.9.14?
> There likely won't be much difference, but I'd like to know if there is.
> Thanks,
> Jason LeRoy Wharton
Jason, et al,

I finally found the REAL culprit for my performance hit ... it was the DevEx grid itself. The IBOQuery(ies) were running quite acceptably when NOT hooked up to the grid. Also found the solution -- one I should have already known, having faced it before. Thought I should pass it on, for others who perchance encounter a similar problem.

First, the grid's TcxGridDBTableView.DataController.DataModeController.GridMode is set to True, at design-time.
Then, in the code, just after the grid's driving query is opened, set TcxGridDBTableView.DataController.DataModeController.GridModeBufferCount = query.RecordCount. (This assures that the scrollbars will work properly, scrolling directly to the bottom rather than in fits & starts). With this done, 29k-plus records now display in 2 -3 seconds.

Thanks, everybody, for the useful pointers and hints.

Lane Campbell
NW Software