[odb-users] Example of Pagination Required.

[Boris Kolpackov]

Hi Kanwar,

Kanwar Manish <kanwarmanish at gmail.com> writes:

> Can someone please point me to an example of pagination using ODB? Or
> how it can done using ODB?

Can you be a bit more specific about what you are trying to achieve?
Generally, however, this will be database-specific, so it will also
be helpful to know which one you are using.

One database-independent mechanism that you may find useful (again,
hard to say without knowing more details about your use-case) are
uncached query results. Essentially, when uncached results are
used, each object is sent from the server as required instead of
buffering the whole result set in the client's memory. This is
not exactly pagination (since some resources, such as the connection
as well as the table on the database, are still going to be blocked
or locked for as long as you are iterating over the result) but it
may be close enough. Uncached results are supported by all the
databases ODB currently supports except PostgreSQL.

Boris