Closed slimnate closed 9 months ago
SQLite does not have good support for pagination of sorted/filtered results- see: https://stackoverflow.com/questions/4481388/why-does-mysql-higher-limit-offset-slow-the-query-down#comment31211780_16935313
So instead we will need to migrate to an implementation of SQL server, I will use PostgreSQL for this.
SQLite does not have good support for pagination of sorted/filtered results- see: https://stackoverflow.com/questions/4481388/why-does-mysql-higher-limit-offset-slow-the-query-down#comment31211780_16935313
So instead we will need to migrate to an implementation of SQL server, I will use PostgreSQL for this.