On 21 Mar 2018, at 5:39pm, Jonathan Moules <jonathan-li...@lightpear.com> wrote:
> After a couple of hours of investigation, it's only slow when there is either > no ORDER BY, or if I use DESC (which is what I need). If I use ORDER BY u.url > ASC - it's near instantaneous. You have a query which gets faster when you add an ORDER BY clause ? That's not meant to happen. Are you using an up-to-date version of SQLite ? Are you executing the query using the sqlite shell tool ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users