On Dec 25, 2008, at 5:01 AM, Jason Freund wrote: > 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?
If you post the performance test program I'll take a look at it. Dan. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
