Using database cursor instead of skip and limit

Question

I'm not sure if the Cursor defined in this Xodus ticket is the typical database cursor or not, but is there a way to support database cursors with Xodus?

For example, instead of the normal skip/limit approach, a cursor can be used to resume retrieval of the results.

Is there a way to use a cursor instead of skip and limit with Xodus?

score 2 · Accepted Answer · answered Jan 19 '21 at 12:50

2

In the Environments API there are aleady cursors. The ticket mentioned is about so called persistent cursors in the EntityStore API that could survive through changing transaction and even EntityStore close/open. It's very unlikely that this feature would ever be implemented.

answered Jan 19 '21 at 12:50

Vyacheslav Lukianov

1,913
8
12

So cursor only works within the same transaction context? So it's not usable for pagination in a user interface? – Fireburn Mar 09 '21 at 10:01

Using database cursor instead of skip and limit

1 Answers1