|Subject||RE: [firebird-support] Delphi + Firebird - IBX or what?|
> -----Original Message-----See (http://www.fbtalk.net/viewtopic.php?id=142) for a list of Delphi
> I am looking for free or low-cost component solution for
> using Firebird from Delphi.
component suites. My favourite is MDO, which is based on IBX and open
> Until now I used IBX with standard Delphi visual componentsTDBGrid uses its own internal paging mechanism, it will only load the
> (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?
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
> I know I could use my own grids and then use limited selectTIBSQL is a lot faster than TIBQuery, however, this component can't be
> (select first etc.)... Anything smarter?
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.