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.
sqlite-users mailing list