On Tue, Jan 12, 2010 at 5:28 AM, ve3meo <holden_fam...@sympatico.ca> wrote:
> Max Vlasov <max.vla...@...> writes: > > For 3.5.4 and 3.6.17 which executed in ~240s: > "order", "from", "detail" > > And for 3.6.20 which executed the same query in ~2500s: > "order","from","detail" > If you remove first numeric values columns and compare the output from the EXPLAIN QUERY PLAN, you will see that the difference is just the names of the indexes (idxFamilyFatherID vs idxFamilyMotherID). Are you sure you have identical tests for your comparison? I mean these are the same data sets with the same scheme? I'm asking because I doubt that different sqlite versions just randomly choose Mother vs Farther in the same namespace )) It does matter to compare identical data since we here analize minor changes and such difference in names makes analizing more difficult. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
