Oracle 8 Performance Scrollable Result Sets Last/First

From: Horst Walter (unkwb_at_web.de)
Date: 03/24/04 

Date: 24 Mar 2004 06:49:58 -0800

DB: Oracle8i Enterprise Edition Release 8.1.7.4.0
Thin Drivers

I use the "standard" trick to get the size of a ResultSet (scrollable) 

--
rs.last();
int s = rs.getRow();
rs.beforeFirst();
--
In my case this is pretty slow, e.g. much slower than a COUNT(*) for
the same query.
Is it - maybe in this case - that the drivers reads all rows rather
then jumping to the last. Could it be that this is not backed up by a
cursor on the server side?
Regrads
HW