Skip to content

Instantly share code, notes, and snippets.

@wankdanker
Created April 16, 2012 18:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wankdanker/2400514 to your computer and use it in GitHub Desktop.
Save wankdanker/2400514 to your computer and use it in GitHub Desktop.
node-mysql-bindings-benchmarks + node-odbc
./bin/node-mysql-bindings-benchmark.js
Benchmarking CPP-MySQL:
**** Benchmark initialization time is 0.00s
**** 1000000 escapes in 0.17s (5882352/s)
**** 1000 sync reconnects in 0.09s (11111/s)
**** 10000 sync insertions in 0.16s (62500/s)
Benchmarking PHP-MySQL:
**** Benchmark initialization time is 0s
**** 1000000 escapes in 0.66s (1508394/s)
**** 1000 sync reconnects in 0.23s (4307/s)
**** 10000 sync insertions in 0.46s (21957/s)
**** 10000 rows sync selected in 0.06s (166028/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
**** Benchmark initialization time is 0.006s
**** 1000000 escapes in 0.651s (1536098/s)
**** 1000 sync reconnects in 0.2s (5000/s)
**** 10000 sync insertions in 0.449s (22272/s)
**** 10000 async insertions in 0.692s (14451/s)
**** 20000 rows sync (fetchObject in loop) selected in 0.089s (224719/s)
**** 20000 rows async (fetchAll) selected in 0.08s (250000/s)
Benchmarking felixge-node-mysql:
**** Benchmark initialization time is 0.007s
**** 1000000 escapes in 1.471s (679810/s)
**** 10000 async insertions in 0.993s (10070/s)
**** 10000 rows async selected in 0.235s (42553/s)
The "sys" module is now called "util". It should have a similar interface.
Benchmarking sidorares-nodejs-mysql-native:
**** Benchmark initialization time is 0.006s
**** 10000 async insertions in 0.964s (10373/s)
**** 10000 rows async selected in 0.377s (26525/s)
Benchmarking mariano-node-db-mysql:
**** Benchmark initialization time is 0.005s
**** 1000000 escapes in 1.172s (853242/s)
**** 10000 async insertions in 0.906s (11038/s)
**** 10000 rows async (fetchAll) selected in 0.07s (142857/s)
Benchmarking node-odbc-mysql:
**** Benchmark initialization time is 0.006s
**** 10000 async insertions in 1.738s (5754/s)
**** 10000 rows async (fetchAll) selected in 0.061s (163934/s)
All benchmarks finished
@Sannis
Copy link

Sannis commented Apr 18, 2012

Very good results for selecting. Can you send me a pull request with node-odbc-mysql support for node-mysql-bindings-benchmark?

@wankdanker
Copy link
Author

@Sannis, will do.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment