On 24 Oct 2016, at 10:11am, Rowan Worth <row...@dug.com> wrote: > However I see you already have an index 'InternalName' which covers the > 'internalvalue' column, so not sure why that isn't being used. Maybe it's > confused by the DESC or the MySQL back-ticks?
I think it's the "DESC". Since SQLite understands how to search an index backwards when it needs to, try dropping the DESC on that index and see if the problem goes away. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
