> ### PROBLEM > > With Sqlite 3.6.17 the following query executes in 12ms. > > --------------------------------------- > SELECT a.number > FROM a, fts > WHERE > a.number=fts.docid > ORDER BY a.date desc > LIMIT 20 > --------------------------------------- > > > With Sqlite version 3.6.23 the same query executes in *3238ms*.
Hopefully fixed by this change: http://www.sqlite.org/src/ci/9e075e70f0 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users