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. Keep up the good work! :-) Jochi Martínez www.bfreenews.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
