>- my badly written sql takes about 3'40", (on my windows pc) >- your neater version takes about 7'20",(on my windows pc) >==> Do you see the same ratio ? I don't catch why yours is slower.
One uses tables for the join constants and the other (slower one) dynamically regenerates the constant table each time it is needed by re-running the recursive CTE which dynamically generates the constants. Or at least that is what it looks like when you request SQLite to EXPLAIN itself ... Though I could be mistaken ... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
