Subject Re: [firebird-support] Re: InterbaseExpress
Author Ann W. Harrison
Alan McDonald wrote:
> you could still manage the selectio of these 280000 records in a far more
> efficient manner then just select *.
> one way is paging thru them with first skip syntax.

Oh,don't do that. The skip actually reads and discards the skipped
records - MUCH more expensive than just reading them sequentially!

> another is to use a master child relation to walk thru a hierarchy of
> master/child/child relations which makes the bottom child result sets small.

That would work!