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

Reply via email to