On Fri, 2008-12-26 at 18:43 -0500, Aaron Bockover wrote:
> Just out of curiosity, I wanted to try a simple test with SQLite. On
> openSUSE 11.1, sqlite3 is at version 3.5.9. I installed 3.6.7 from
> source into a private prefix and ran the following test against both
> versions:
>
> (for ((i=0;i<100;i++)); do (time $SQLITE ~/.config/banshee-1/banshee.db
> 'select * from CoreTracks' 1>/dev/null) 2>&1 | awk
> '/^real/{sub(/^real[0-9\t]+m/,""); sub(/s$/,""); print}'; done;) | awk
> '{sum = sum + $0; } END { print sum / NR }'
>
> SYSTEM SQLITE (3.5.9)
> =====================
> export SQLITE=sqlite3
> 0.14098 (average time to select all columns from 5120 rows)
>
> PRIVATE SQLITE (3.6.7)
> ======================
> export SQLITE=./sqlite3
> 0.11208 (average time to select all columns from 5120 rows)
That seems to be in line with the 15% improvement the sqlite guys are
anouncing :
http://www.sqlite.org/malloc.html#lookaside
> Nice to see a good deal of gain here, but I'm fairly pissed that the
> sqlite3 in 11.1 is from May 2008.
Well, maybe it was a safer choice : there were potential database
corruption bugs in 3.6.x versions in November...
http://www.sqlite.org/changes.html
Even in Gentoo, the stable version is still 3.5.9 ;)
--
Bertrand Lorentz <bertrand lorentz gmail com>
> http://flickr.com/photos/bl8/ <
Attachment:
signature.asc
Description: This is a digitally signed message part