Thanks. I know about the technique your mentioned, but the point is not about the use of offset or not. The same issue will happen but using a key. See my other reply above.
- [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