On 10/24/16, Simon Slavin <slav...@bigfraud.org> wrote: > > 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.
He already has another index without the DESC :-\ I think those indexes are redundant. I cannot, off hand, think of a set of queries that would benefit from having them both. SQLite is perfectly capable using a DESC index for an ASC scan and vice verse. I don't think the MySQL-backtics are a factor either. Though they should be fixed, SQLite at least is able to deal with them. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users