On 10/24/16, Simon Slavin <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
