Analyze the addition of a page() QuerySet method

Description

Currently, there is no efficient way to paginate results in cqlengine. It is possible to slice a queryset, but internally, all results up to the 'stop' index will be materialized in the result cache.

We should be able to add a page() method to fill the result cache with a single page at a time. This will still be a full table scan, but we will avoid memory issue with a big result cache.

Environment

None

Pull Requests

None

Assignee

Unassigned

Reporter

Alan Boudreault

Fix versions

None

Labels

PM Priority

None

External issue ID

None

Doc Impact

None

Reviewer

None

Size

None

Pull Request

None

Sprint

Py P-CQLENG3

Affects versions

Priority

Major