Skip to content

Instantly share code, notes, and snippets.

@BanzaiMan
Created July 18, 2009 01:06
Show Gist options
  • Save BanzaiMan/149366 to your computer and use it in GitHub Desktop.
Save BanzaiMan/149366 to your computer and use it in GitHub Desktop.
sqlite3 benchmarking with C, DL, and FFI drivers
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