Open dcdourado opened 1 year ago
As we can see on https://www.eversql.com/faster-pagination-in-mysql-why-order-by-with-limit-and-offset-is-slow/, we should be able to use more fields (imagine a case of a table with UUID primary key). Using the created_at/inserted_at field to order it will boost the query performance
19 alters the backfill strategy to seek method but it only enables one field being used as the seek column.
As we can see on https://www.eversql.com/faster-pagination-in-mysql-why-order-by-with-limit-and-offset-is-slow/, we should be able to use more fields (imagine a case of a table with UUID primary key). Using the created_at/inserted_at field to order it will boost the query performance