On Mon, Jan 11, 2010 at 4:17 AM, Hub Dog <hub...@gmail.com> wrote: > I think I found a performance regression bug of sqlite 3.6.1 8. A sql will > cost 1800 seconds to return the query result with sqlite 3.6.18 and with > the > previous version it only cost about 170 seconds. >
I have a suggestion for you. If you're able to compare the queries in different versions, can you EXPLAIN them (I suppose you're aware of this operator that should be appended before your query), export results from different sqlite versions into two csv files and compare them as texts (Ms word, diff, whatever). I think there will be not much difference in VDBE code. If there's a difference, post it here. But if the code sequences are the same, there's a probably a problem in your code or data files, not sqlite. I think you're following the idea. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
