Hello,

After doing some general (Oracle) jdbc performance tests I noticed that the ResultSet.absolute() and ResultSet.relative are slow for large (50000 records) sets.

For example, to access record 50000 takes about 1437 ms, while record 50 takes 15 ms. This is particularly relevant for large lists and paging. There also seems to be a much higher memory usage when using absolute() and relative().

One way around this is to use a nested select:

select * from (
select query.*, rownum rnum from (
select c.* from code c order by code_type
) query where rownum <= :MAX_ROW )
where rnum >= :MIN_ROW order by rnum

See http://asktom.oracle.com/pls/ask/f?p=49 ... 7412348064

Does Hibernate support such paging? Is there a way to make it database indepenedent (via a dialect)? Do other JDBC drivers have the same performance? How would I build hibernate that uses this paging?

Thanks

Yes Hibernate supports this and Yes it is controlled by the dialect. I suggest you try it out.