GitHub

Unexpected-Row-Count-with-LIMIT-and-OFFSET-in-SQL-mhcwy

This seems straightforward, but if `large_table` doesn't have enough rows beyond the offset (e.g., fewer than 100 rows after row 1000), the query might not return an ...
GitHub

Pagination performance issue with ROW_NUMBER() vs LIMIT/OFFSET – prefer native pagination (limit&offset)

Currently, the ORM generates the following SQL for a simple paginated query: SELECT anon_1.masterdata_product_id, anon_1.masterdata_product_country_id FROM ( SELECT ...