Re: [odb-users] scrollable cursors
shekli at list.ru
Fri Jun 14 03:53:55 EDT 2013
Среда, 12 июня 2013, 15:15 +02:00 от Boris Kolpackov <boris at codesynthesis.com>:
>александр вершинин < 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.
More information about the odb-users