the ofbiz pagination

[和风赛跑]

the ofbiz use the CURSOR to pagination rather than "select * from(select a.*, ROWNUM  RN from(...)) where RN BETWEEN .. AND .." if the database is oracle.
 
 So anyone can give the performance detail between the above two imp