Hi,
We recently upgraded from 3.4.0 to 3.6.5, and noticed that our little, internal sqlite benchmark test program performed much worse on most operations with the new version. We expected to see an improvement because 3.6.1 advertises a performance enhancement with the lookaside buffer. Our small performance test app showed regressions averaging 25% slowdown for all read and write operations, but one test case was very striking: going from 2ms in 3.4.0 to 170ms in 3.6.5. This test prepared a "SELECT DISTINCT from one table with an ORDER BY, COLLATE, and LIMIT" and then stepped 50 times through that statement. I was wondering if anyone else encountered a regression, and whether I can interest someone from the dev community in looking into it, or whether I should file a bug? Also, I may be able to do more builds to help isolate when the regressions were introduced, but I'm not sure if there is an easy way to download code for earlier releases? I haven't used cvs before - is there an easy way to checkout the code for some kind of "label" that represents an official release, or is there a depot somewhere that I can just download earlier distros? Our platform is a TI 3430 ARM5 ~600 MHz machine + 256MB NAND RAM, 32bit bus to memory. I can send a zip file of the smallest test program (includes data) that demonstrates the biggest regression to anyone who is interested. Thanks, Jason _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
