Created
July 18, 2009 01:06
-
-
Save BanzaiMan/149366 to your computer and use it in GitHub Desktop.
sqlite3 benchmarking with C, DL, and FFI drivers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
surfboard:sqlite3-ruby-ffi asari$ git log --pretty=oneline -1 | |
3c89051443842b46f37d48914db5d66c05965719 allow column_decltype to get utf16 parameter avoid duplicate of sqlite3_step symbol first pass at value_blob, value_text and column_blob. more simplistic view of create_function. | |
surfboard:sqlite3-ruby-ffi asari$ ruby -v -rubygems -I lib -I ext -I test test/native-vs-dl-vs-ffi.rb | |
ruby 1.8.6 (2008-08-11 patchlevel 287) [universal-darwin9.0] | |
database creation... | |
user system total real | |
dl 0.180000 0.160000 0.340000 ( 0.351612) | |
native 0.130000 0.160000 0.290000 ( 0.293039) | |
ffi 0.190000 0.170000 0.360000 ( 0.364955) | |
database open... | |
user system total real | |
dl 0.130000 0.070000 0.200000 ( 0.198590) | |
native 0.140000 0.070000 0.210000 ( 0.217930) | |
ffi 0.120000 0.070000 0.190000 ( 0.192488) | |
insertions | |
user system total real | |
dl 0.090000 0.000000 0.090000 ( 0.092984) | |
native 0.040000 0.010000 0.050000 ( 0.045711) | |
ffi 0.190000 0.600000 0.790000 ( 1.480809) | |
insertions using prepared statement | |
user system total real | |
dl 0.090000 0.000000 0.090000 ( 0.091640) | |
native 0.050000 0.000000 0.050000 ( 0.058902) | |
ffi 0.030000 0.000000 0.030000 ( 0.033031) | |
queries | |
user system total real | |
dl 0.350000 0.020000 0.370000 ( 0.375877) | |
native 0.160000 0.020000 0.180000 ( 0.181752) | |
ffi 0.150000 0.020000 0.170000 ( 0.172081) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment