On 22 Mar 2018, at 9:24pm, Jonathan Moules <jonathan-li...@lightpear.com> wrote:
> But when I stick an "ORDER BY" on the end (either ASC or DESC), the > processing time shoots up to 0.15s. The EXPLAIN between the two is > considerably different so it seems the ORDER BY is getting it to use a > sub-optimal query plan. Hi, Jonathan. Could you post details similar to the ones in that post, but instead of using EXPLAIN use EXPLAIN QUERY PLAN ? This will give results on a scale which is easier to understand in the context of your queries and indexes. <https://www.sqlite.org/eqp.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
