|Subject||Re: [IB-Architect] 'Order By' Issue|
> From: Ann W. HarrisonI am glad you said "often" instead of "always" (like Jim).
> >If ordering can be done *without* a temporary result set,
> >e.g. via index navigation, you would get results very
> >quickly (minimal processing before returning a record).
> >Can the database engine currently handle this?
> Yes, and for large result sets it is often SLOWER to
> finish than a sort. The first row comes faster, but
> the total time is LONGER. Really and truly. Tested
> and verified.
Considering that result set must be passed to client,
network speed can become more important than disc speed.