diff options
Diffstat (limited to 'oslo_db/sqlalchemy/utils.py')
-rw-r--r-- | oslo_db/sqlalchemy/utils.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/oslo_db/sqlalchemy/utils.py b/oslo_db/sqlalchemy/utils.py index 97a28c6..f3db1dc 100644 --- a/oslo_db/sqlalchemy/utils.py +++ b/oslo_db/sqlalchemy/utils.py @@ -155,6 +155,11 @@ def paginate_query(query, model, limit, sort_keys, marker=None, marker, then the actual marker object must be fetched from the db and passed in to us as marker. + The "offset" parameter is intentionally avoided. As offset requires a + full scan through the preceding results each time, criteria-based + pagination is preferred. See http://use-the-index-luke.com/no-offset + for further background. + :param query: the query object to which we should add paging/sorting :param model: the ORM model class :param limit: maximum number of items to return |