Subject RE: [firebird-support] Delphi + Firebird - IBX or what?
Author Si Carter
> -----Original Message-----
> I am looking for free or low-cost component solution for
> using Firebird from Delphi.

See ( for a list of Delphi
component suites. My favourite is MDO, which is based on IBX and open

> Until now I used IBX with standard Delphi visual components
> (e.g. DBGrid).
> But, when having large queries, programs may work slower,
> even stop responding because dbgrid/TIBQueries are fully populated.
> Is there anything I could do to prevent it?

TDBGrid uses its own internal paging mechanism, it will only load the
records as you scroll through, you can improve the scroll speed by moving to
the end of the data set first, but on large data sets you will see a
significant lag.

> I know I could use my own grids and then use limited select
> (select first etc.)... Anything smarter?

TIBSQL is a lot faster than TIBQuery, however, this component can't be
linked to data aware controls and is restricted to a forward-only cursor.
The only real solution, IMO, is to reduce the result set that is being
returned and perhaps consider using some sort of paging mechanism.


Si Carter