> > - None I have seen so far give an indication of how many datasets
> > exist in the result set (i.e. by sizing the scroll-bar appropriately).
>
> I'd rather use the word 'records' because 'dataset' means the same thing
> as 'result set'.

I'd rather use the word "row" because "record" is what's stored on disk,
not what comes back to the client (as this can be a combination of
multiple records) ;-)

> > Even database-managers that should be very sophisticated in this task,
> > often fail in this regard.
>
> This is because 'select count()' is slow in most cases. There is no way
> to know about row number efficiently.

Indeed, you simply don't know the number of result set rows.

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