Hello Filip,

> > Actually, try a "fetch all" and see which one is slower.
>
> Sure, i agree when doing a "fetch all" performance won't differ that
> much but that's what i'm trying to avoid. I don't want them all "at
> once" and the additional sort forces the "fetch all" on the server side.

Then don't ask for them "all at once" :-)

Seriously, you're asking the server for a complete resultset which
needs to be prepared.

In general, I look to indices for quick lookups, not for sorting. If
a sort can use an index, that's - usually - an added benefit, but not
at all the "normal" way of things.

> BTW: Is Arno still running his Dutch FireBird newsgroup?

He sure does.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com