First queries are unbounded

[jorgecarleitao]

Hi,

Thank you for creating this library.

I am a bit puzzled by the queries that this library is producing. Given a query(Model).order_by(*pks), this library is generating 3 queries when get_page(query, 20) is used:

• a SELECT * FROM ... ORDER BY pk
• a SELECT * FROM ... ORDER BY pk
• a SELECT * FROM ... ORDER BY pk ASC LIMIT 21

(observed by the statements outputted by the sqlalchemy.engine logger to INFO)

Do we need to perform the first two (equal) unbounded statements against the table to retrieve the bookmarks? These statements are quite expensive in a large table

[jorgecarleitao]

Nvmd, this has been fixed in a subsequent release. 👍