This has always been how it has worked, since it scaled the scroll bar
against the visited records. Even with FetchAll it does not actually
scan everything until the records are viewed. It is compromise between
the speed of bringing the display up, over visiting ALL the records of a
potentially large result set.

Just try a Last() and then First() on the query to see how your response
time looks.

Having said that, the improvements in Firebird 1.5 may well mean that
compromises made for Interbase can now be revisited, and so it may be
that a proper scaling would not now cause as big a delay as in the past ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services