We use same thechnique with TIBOQuery.
In fact with open runtime order billing transactions dataset of 700.000
record from first to last record takes from
20 - to 6 seconds. And open Products, Wares and services catalog with
~140.000 records from 1 to last takes about 1 - 4 secs.
Adomas


Vahan Yoghoudjian wrote:

> Hi Jason, what we really want to do is the following:
>
>An account has a few 100,000 transactions.
>Of course it is not conceivable to show them all at once.
>
>To show those transactions, we would like to implement the following
>interface:
>A form is opened, which contains a grid.
>This grid shows the transactions of the said account, starting from the
>latest transactions, ie the latest transaction for that account is near the
>bottom of the grid.
>The cursor bar is on the latest transaction.
>The user may click on the up arrow, and reach the topmost line on his grid.
>If he clicks on the up arrow again, the grid shows more of the former
>transactions.
>Of course, if the user is stubborn enough to keep clicking on the up arrow
>all day, he will eventually go through the 100,000 transactions, but this is
>unlikely to happen.
>Now how much the user will peek backwards at the account history cannot be
>told in advance, and remains his choice.
>
>How could this interface be implemented, using a TIBOTable or is there
>another component that would do this job ?
>
>Note that TIBOTable would work perfectly for us if we wanted to position on
>the first record when we open the table and let the user scroll down as he
>wished, but we want to position on the last record and let the user scroll
>up, is that possible without fetching all the records at once?
>
>
>