Searched hist:"7 f9cb794b2583b8ea20b5fc073828e3b9af7b918" (Results 1 – 1 of 1) sorted by relevance
| /plugin/struct/meta/ |
| H A D | Search.php | 7f9cb794b2583b8ea20b5fc073828e3b9af7b918 Mon Feb 15 14:55:35 UTC 2016 Andreas Gohr <gohr@cosmocode.de> implemented limit/offset with full result set count
We always sleect the full result set, then skip and fetch only what we
need, counting the full set. This gives us all the data we need for
proper paging (with jump to end or page numbers) and is the recommended
way to do it in SQLite:
http://sqlite.1065341.n5.nabble.com/SQL-CALC-FOUND-ROWS-td5169.html
|