Re[2]: [odb-users] scrollable cursors

александр вершинин shekli at list.ru
Fri Jun 14 03:53:55 EDT 2013


 Thanks!


Среда, 12 июня 2013, 15:15 +02:00 от Boris Kolpackov <boris at codesynthesis.com>:
>Hi Alexander,
>
>александр вершинин < shekli at list.ru > writes:
>
>> Could you please answer does ODB support scrollable cursors with
>> Postgres like  ScrollableResults in hibernate?
>
>No, ODB result sets only support forward iteration and the reason
>for this is that scrollable results, in most databases, have very
>poor performance compared to the streaming ones.
>
>If you are looking for scrollable results in order to support
>pagination, then a better option would be to use the Postgres
>LIMIT and OFFSET clauses. The archives of this mailing list
>have some examples, if you are interested.
>
>Boris


-- 
александр вершинин


More information about the odb-users mailing list