Just to let you know, the solution using SELECT * FROM (query with offset/limit) works perfectly well. Thanks a lot for the suggestion!
- [sqlite] Performance issue with CTE Philippe Riand
- [sqlite] Performance issue with CTE E.Pasma
- [sqlite] Performance issue with CTE Clemens Ladisch
- [sqlite] Performance issue with CTE Kees Nuyt
- [sqlite] Performance issue with CTE Philippe Riand
- [sqlite] Performance issue with CTE Philippe Riand
- [sqlite] Performance issue with CTE Philippe Riand