On 12 Jan 2018, at 10:31am, Eric Grange <egra...@glscene.org> wrote: > >> This should not be true. You should not be using OFFSET. Your queries >> should be something like > > That was with only the "value" field being indexed (so without a rank > field), is there a better way than OFFSET in that case ?
Can’t think of one. OFFSET is the easiest way to get what you want if you’re not storing the values you’re searching/sorting on. But as you’ve seen, SQLite derives OFFSET by compiling the whole list, from the first result, and simply not reporting the first entries. So it’s slow. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users