On Oct 7, 2010, at 5:50 PM, Shopsland gmail wrote: > Hi, > > Given this simple query with a subquery in FROM and a join with a > FTS3 table: > > SELECT news1.number, fts_news.title > FROM (SELECT number FROM news LIMIT 50) as news1, fts_news > WHERE news1.number=fts_news.docid > > The query runs in 15ms in 3.6.23. The same query runs in *8 seconds* > in 3.7.2. > > If I do an explain query plan I get this: > > ### 3.6.23 > Order | From | detail > 0 | 0 | Table News > 0 | 0 | Table AS News1 > 1 | 1 | TABLE fts_news VIRTUAL TABLE INDEX 1: > > ### 3.7.2 > Order | From | detail > 0 | 0 | Table News > 0 | 1 | TABLE fts_news VIRTUAL TABLE INDEX 1: > 1 | 0 | Table AS News1 > > It seems that something changed in the query optimizer.
Thanks for the report. We think this has been fixed in fossil already. 3.7.3 should be the same as 3.6.23 for this query. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
