Recently we found a problem that Oracle JDBC driver simulates scrolling operations in result set by caching entire result in memory. Certainly it rises a problem for multi million result. How do you resolve problem of: 1. getting number of record in result set? 2. scrolling to first shown record?
Is rs.next() perform well, or some other trick like including max(rownum) in a query will work better?