-
Notifications
You must be signed in to change notification settings - Fork 10
Home
Sannis edited this page Oct 29, 2012
·
32 revisions
Modules:
{ "mysql" : "2.0.0-alpha3"
, "mysql-libmysqlclient" : "1.5.1"
, "mysql-native" : "0.4.7"
, "db-mysql" : "0.7.6"
, "mariasql" : "0.1.9"
}Benchmark code: 0bedcf1
libmysqlclient and server: 5.5.28_0 (macports)
libmariadbclient: 5.5.27 (bundled)
factor: 1
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| Name | Async | TypeCast | Init | Escapes | Reconnects | Inserts | Selects |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| C | | | 0.239 | 5994556 | 3433 | 10411 | 421923 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| PHP | | | 0.165 | 1202850 | 1615 | 7434 | 342266 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mariasql | V | | 0.303 | 1650047 | - | 6641 | 567721 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient | V | V | 0.18 | 1254647 | 1992 | 5658 | 376487 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient * | | V | 0.14 | 1598524 | 3930 | 12888 | 385866 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| db-mysql | V | V | 0.135 | 792331 | - | 8431 | 187482 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mysql | V | V | 0.279 | 901494 | - | 1794 | 226058 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mysql * | V | | 0.331 | 878861 | - | 1744 | 295726 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+
| mysql-native | V | V | 0.13 | - | - | 8356 | 242855 |
+------------------------------+-------+----------+-------+-----------+------------+---------+---------+factor: 10
?Modules:
- PHP: 5.3.10
- db-mysql: 0.7.6
- mysql: 2.0.0-alpha3
- mysql-libmysqlclient: 1.3.3
- mysql-native: 0.4.4
- mariasql: 0.0.4
Benchmark code: 4397e4c
MySQL server: 5.5.25a (Community Server) (from stock XAMPP 1.8.0)
libmariadbclient(/libmysqlclient): 5.5.25
Hardware: Intel Core i7-860 @ 2.80GHz / 8GB RAM / Ubuntu 12.04 Server.
Run #1 config:
- factor: 6
- SELECT query: SELECT * FROM test_table
+----------------------------------+-------+-----------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+-----------+------------+---------+---------+
| C | 0.069 | 11497339 | 3258 | 6725 | 819637 |
+----------------------------------+-------+-----------+------------+---------+---------+
| PHP | 0.066 | 2228828 | 2442 | 4444 | 316039 |
+----------------------------------+-------+-----------+------------+---------+---------+
| db-mysql | 0.066 | 1694915 | - | 2944 | 161290 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql | 0.065 | 973868 | - | 1971 | 338983 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient | 0.063 | 2094972 | 3057 | 3646 | 118577 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-native | 0.077 | - | - | 4450 | 280374 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mariasql | 0.067 | 3391747 | - | 6866 | 465116 |
+----------------------------------+-------+-----------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+-----------+------------+---------+---------+Run #2 config:
- factor: 6
- SELECT query: SELECT *, x’00FFAABBCCDDEE’ FROM test_table
+----------------------------------+-------+-----------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+-----------+------------+---------+---------+
| C | 0.065 | 11502564 | 3543 | 11423 | 710996 |
+----------------------------------+-------+-----------+------------+---------+---------+
| PHP | 0.066 | 2105848 | 2465 | 4421 | 259898 |
+----------------------------------+-------+-----------+------------+---------+---------+
| db-mysql | 0.061 | 1630435 | - | 2994 | 85470 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql | 0.065 | 971817 | - | 1985 | 252101 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient | 0.064 | 2069679 | 2990 | 3611 | 52174 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-native | 0.066 | - | - | 4570 | 202020 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mariasql | 0.076 | 3329634 | - | 7032 | 357143 |
+----------------------------------+-------+-----------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+-----------+------------+---------+---------+Modules:
- PHP: 5.3.10
- db-mysql: 0.7.6
- mysql: 2.0.0-alpha3
- mysql-libmysqlclient: 1.3.3
- mysql-native: 0.4.4
- mariasql: 0.0.2@654d891
Benchmark code: f01b517
MySQL server: 5.5.25a (Community Server) (from stock XAMPP 1.8.0)
libmariadbclient(/libmysqlclient): 5.5.25
Hardware: Intel Core i7-860 @ 2.80GHz / 8GB RAM / Ubuntu 12.04 Server.
+----------------------------------+-------+-----------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+-----------+------------+---------+---------+
| C | 0.099 | 10656926 | 2907 | 9609 | 461147 |
+----------------------------------+-------+-----------+------------+---------+---------+
| PHP | 0.067 | 1929585 | 2531 | 6359 | 237965 |
+----------------------------------+-------+-----------+------------+---------+---------+
| db-mysql | 0.069 | 1483680 | - | 3433 | 128205 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql | 0.072 | 893655 | - | 1998 | 232558 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient | 0.067 | 2070393 | 2558 | 5061 | 114943 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-native | 0.066 | - | - | 4634 | 277778 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mariasql | 0.077 | 2770083 | - | 7123 | 322581 |
+----------------------------------+-------+-----------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+-----------+------------+---------+---------+Modules:
- PHP: 5.3.10
- db-mysql: 0.7.6
- mysql: 2.0.0-alpha3
- mysql-libmysqlclient: 1.3.3
- mysql-native: 0.4.4
- mariasql: 0.0.2
MySQL server: 5.5.25a (Community Server) (from stock XAMPP 1.8.0)
libmariadbclient(/libmysqlclient): 5.5.25
Hardware: Intel Core [email protected]/8GB RAM/Ubuntu 12.04 Server.
+----------------------------------+-------+-----------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+-----------+------------+---------+---------+
| C | 0.072 | 9311959 | 3332 | 4713 | 420355 |
+----------------------------------+-------+-----------+------------+---------+---------+
| PHP | 0.068 | 1946794 | 2498 | 4431 | 201191 |
+----------------------------------+-------+-----------+------------+---------+---------+
| db-mysql | 0.066 | 1628664 | - | 3129 | 129870 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql | 0.068 | 834725 | - | 2112 | 232558 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-libmysqlclient | 0.068 | 2958580 | 3534 | 3726 | 133333 |
+----------------------------------+-------+-----------+------------+---------+---------+
| mysql-native | 0.071 | - | - | 4127 | 185185 |
+----------------------------------+-------+-----------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+-----------+------------+---------+---------+
| mariasql | 0.061 | 3058104 | - | 7225 | 333333 |
+----------------------------------+-------+-----------+------------+---------+---------+Modules:
{ "mysql" : "2.0.0-alpha3"
, "mysql-libmysqlclient" : "1.3.3"
, "mysql-native" : "0.4.4"
, "db-mysql" : "0.7.6"
}+----------------------------------+-------+---------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+---------+------------+---------+---------+
| C | - | - | - | - | - |
+----------------------------------+-------+---------+------------+---------+---------+
| PHP | 0.304 | 1757738 | 3395 | 13768 | 345888 |
+----------------------------------+-------+---------+------------+---------+---------+
| db-mysql | 0.448 | 817661 | - | 8787 | 151515 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql | 0.174 | 856898 | - | 2351 | 232558 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-libmysqlclient | 0.125 | 2070393 | 4545 | 12392 | 212766 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-native | 0.161 | - | - | 8818 | 178571 |
+----------------------------------+-------+---------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+---------+------------+---------+---------+Modules:
{ "mysql" : "0.9.6"
, "mysql-libmysqlclient" : "1.3.3"
, "mysql-native" : "0.4.4"
, "db-mysql" : "0.7.6"
}+----------------------------------+-------+---------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+---------+------------+---------+---------+
| C | - | - | - | - | - |
+----------------------------------+-------+---------+------------+---------+---------+
| PHP | 0.089 | 1838201 | 3503 | 13897 | 296342 |
+----------------------------------+-------+---------+------------+---------+---------+
| db-mysql | 0.113 | 727273 | - | 8865 | 178571 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql | 0.101 | 1018330 | - | 8818 | 76923 |
+----------------------------------+-------+---------+------------+---------+---------+
| [email protected] | 0.077 | 1017294 | - | 8734 | 270270 |
+----------------------------------+-------+---------+------------+---------+---------+
| [email protected] | 0.089 | 982318 | - | 8482 | 294118 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-libmysqlclient | 0.083 | 2028398 | 4673 | 11249 | 238095 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-native | 0.109 | - | - | 8795 | 85470 |
+----------------------------------+-------+---------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+---------+------------+---------+---------+Just update with new output style:
+----------------------------------+-------+---------+------------+---------+---------+
| Author and module name | Init | Escapes | Reconnects | Inserts | Selects |
+----------------------------------+-------+---------+------------+---------+---------+
| C | 0.065 | 1821142 | 2824 | 9505 | - |
+----------------------------------+-------+---------+------------+---------+---------+
| PHP | 0.055 | 215623 | 2283 | 8240 | 113219 |
+----------------------------------+-------+---------+------------+---------+---------+
| db-mysql | 0.102 | 345543 | - | 4439 | 52632 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql | 0.106 | 307598 | - | 4149 | 14641 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-libmysqlclient | 0.057 | 613121 | 2469 | 6177 | 52356 |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-native | 0.072 | - | - | 4083 | 80645 |
+----------------------------------+-------+---------+------------+---------+---------+
| odbc | - | - | - | - | - |
+----------------------------------+-------+---------+------------+---------+---------+
node v0.6.14
node-mysql-bindings-benchmarks v0.2.1
[email protected]
[email protected]
[email protected]
[email protected]
Benchmarking CPP-MySQL:
- Benchmark initialization time is 0.00s
- 1000000 escapes in 0.55s (1818181/s)
- 1000 sync reconnects in 0.14s (7142/s)
- 10000 sync insertions in 0.25s (40000/s)
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0.07s
- 1000000 escapes in 6.26s (159631/s)
- 1000 sync reconnects in 0.49s (2025/s)
- 10000 sync insertions in 1.57s (6351/s)
- 10000 rows sync selected in 0.16s (61714/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.071s
- 1000000 escapes in 2.276s (439367/s)
- 1000 sync reconnects in 0.461s (2169/s)
- 10000 sync insertions in 1.465s (6826/s)
- 10000 async insertions in 2.228s (4488/s)
- 20000 rows sync (fetchObject in loop) selected in 0.233s (85837/s)
- 20000 rows async (fetchAll) selected in 0.291s (68729/s)
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.138s
- 1000000 escapes in 3.808s (262605/s)
- 10000 async insertions in 2.483s (4027/s)
- 10000 rows async selected in 1.196s (8361/s)
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.223s
- 10000 async insertions in 4.193s (2385/s)
- 10000 rows async selected in 0.361s (27701/s)
Benchmarking mariano-node-db-mysql:
- Benchmark initialization time is 0.082s
- 1000000 escapes in 3.787s (264061/s)
- 10000 async insertions in 2.307s (4335/s)
- 10000 rows async (fetchAll) selected in 0.184s (54348/s)
node v0.6.0
node-mysql-bindings-benchmarks v0.2.0
[email protected]
[email protected]
[email protected]
[email protected]
Benchmarking CPP-MySQL:
- Benchmark initialization time is 0.00s
- 1000000 escapes in 0.50s (2000000/s)
- 1000 sync reconnects in 0.12s (8333/s)
- 100000 sync insertions in 2.17s (46082/s)
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0.07s
- 1000000 escapes in 1.27s (790182/s)
- 1000 sync reconnects in 0.58s (1721/s)
- 100000 sync insertions in 8.05s (12420/s)
- 100000 rows sync selected in 0.71s (140385/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.075s
- 1000000 escapes in 1.838s (544070/s)
- 1000 sync reconnects in 0.504s (1984/s)
- 100000 sync insertions in 7.821s (12786/s)
- 100000 async insertions in 13.58s (7364/s)
- 200000 rows sync (fetchObject in loop) selected in 1.895s (105541/s)
- 200000 rows async (fetchAll) selected in 1.791s (111669/s)
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.073s
- 1000000 escapes in 2.135s (468384/s)
- 100000 async insertions in 17.957s (5569/s)
- 100000 rows async selected in 2.777s (36010/s)
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.071s
- 100000 async insertions in 18.708s (5345/s)
- 100000 rows async selected in 4.477s (22336/s)
Benchmarking mariano-node-db-mysql:
- Benchmark initialization time is 0.072s
- 1000000 escapes in 2.285s (437637/s)
- 100000 async insertions in 17.902s (5586/s)
- 200000 rows async (fetchAll) selected in 1.437s (139179/s)
node v0.4.12
Sannis/node-mysql-libmysqlclient@5c9c25e2015a3ff73f6e14337e3a692fafadb8cb
felixge/node-mysql@077d985372d87e1e932718ab1955659ad4f803e2
sidorares/nodejs-mysql-native@2b4f1badae440c8321b61f00f073021859635229
Benchmarking CPP-MySQL:
- Benchmark initialization time is 0.00s
- 100000 escapes in 0.01s (10000000/s)
- 1000 sync reconnects in 0.09s (11111/s)
- 10000 sync insertions in 0.06s (166666/s)
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0.06s
- 100000 escapes in 0.06s (1590233/s)
- 1000 sync reconnects in 0.09s (11255/s)
- 10000 sync insertions in 0.4s (25071/s)
- 10000 rows sync selected in 0.05s (213726/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.069s
- 100000 escapes in 0.055s (1818182/s)
- 1000 sync reconnects in 0.146s (6849/s)
- 1000 half-async reconnects in 0.187s (5348/s)
- 10000 async insertions in 1.292s (7740/s)
- 10000 rows sync (fetchAll) selected in 0.05s (200000/s)
- 10000 rows sync (fetchObject in loop) selected in 0.023s (434783/s)
- 10000 rows async (fetchAll) selected in 0.021s (476190/s)
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.076s
- 100000 escapes in 0.141s (709220/s)
- 10000 async insertions in 2.366s (4227/s)
- 10000 rows async selected in 0.301s (33223/s)
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.078s
- 10000 async insertions in 1.76s (5682/s)
- 10000 rows async selected in 0.112s (89286/s)
Sannis/node-mysql-libmysqlclient@0794d12473c8c6a6d135028bd10a4b0ef8adaff7
felixge/node-mysql@0d3f5c4758854689e1df213873e485192a57b947
stevebest/node-mysql@e84302ab7f6a44c0b770f91406bbd497a5ebff85 +my “no password” patch
sidorares/nodejs-mysql-native@a1291a6791db7601c548086419386bf262e2f0ad
Benchmarking CPP-MySQL:
- Benchmark initialization time is 0.00s
- 100000 escapes in 0.05s (1999999/s)
- 1000 sync reconnects in 0.13s (7692/s)
- 10000 sync insertions in 0.20s (49999/s)
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0.1s
- 100000 escapes in 0.15s (655626/s)
- 1000 sync reconnects in 0.73s (1371/s)
- 10000 sync insertions in 0.81s (12352/s)
- 10000 rows sync selected in 0.07s (136364/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.086s
- 100000 escapes in 0.215s (465116/s)
- 1000 sync reconnects in 0.633s (1580/s)
- 1000 half-async reconnects in 0.759s (1318/s)
- 10000 async insertions in 1.344s (7440/s)
- 10000 rows sync (fetchAll) selected in 0.08s (125000/s)
- 10000 rows sync (fetchObject in loop) selected in 0.096s (104167/s)
- 10000 rows async (fetchAll) selected in 0.086s (116279/s)
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.081s
- 100000 escapes in 0.274s (364964/s)
- 1000 async reconnects with .end() in 1.014s (986/s)
- 1000 async reconnects with .destroy() in 1.008s (992/s)
- 10000 async insertions in 2.312s (4325/s)
- 10000 rows async selected in 1.269s (7880/s)
Benchmarking stevebest-node-mysql:
- Benchmark initialization time is 0.091s
- 100000 escapes in 0.228s (438596/s)
- 1000 async reconnects in 1.646s (608/s)
- 10000 async insertions in 3.76s (2660/s)
- 10000 rows async selected in 4.407s (2269/s
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.078s
- 10000 async insertions in 2.003s (4993/s)
- 10000 rows async selected in 0.329s (30395/s)
Sannis/node-mysql-libmysqlclient@46f34af6199f922228f444c5f1317c961dc7d21a
felixge/node-mysq@0d08256fa816d60368ef3b7b182b3e5699b748e7
sidorares/nodejs-mysql-native@a1291a6791db7601c548086419386bf262e2f0ad
Benchmarking CPP-MySQL:
- Benchmark initialization time is 0.00s
- 100000 escapes in 0.05s (1999999/s)
- 1000 sync reconnects in 0.07s (14285/s)
- 10000 sync insertions in 0.12s (83333/s)
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0.07s
- 100000 escapes in 0.14s (718402/s)
- 1000 sync reconnects in 0.23s (4362/s)
- 10000 sync insertions in 0.69s (14569/s)
- 10000 rows sync selected in 0.06s (157721/s)
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.09s
- 100000 escapes in 0.173s (578035/s)
- 1000 sync reconnects in 0.201s (4975/s)
- 1000 half-async reconnects in 0.232s (4310/s)
- 10000 async insertions in 1.126s (8881/s)
- 10000 rows sync (fetchAll) selected in 0.069s (144928/s)
- 10000 rows sync (fetchObject in loop) selected in 0.086s (116279/s)
- 10000 rows async (fetchAll) selected in 0.078s (128205/s)
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.09s
- 100000 escapes in 0.26s (384615/s)
- 1000 async reconnects with .end() in 0.886s (1129/s)
- 1000 async reconnects with .destroy() in 0.836s (1196/s)
- 10000 async insertions in 2.018s (4955/s)
- 10000 rows async selected in 0.937s (10672/s)
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.07s
- 10000 async insertions in 1.766s (5663/s)
- 10000 rows async selected in 0.302s (33113/s)
Sannis/node-mysql-libmysqlclient@f1d61ee075f4781f8e00fcb4c25e36b133b64755
felixge/node-mysql@5eca50ca33392cce432231d044feaa1e24b094b6
sidorares/nodejs-mysql-native@a1291a6791db7601c548086419386bf262e2f0ad
Benchmarking Sannis-node-mysql-libmysqlclient:
- Benchmark initialization time is 0.123s
- 1000000 escapes in 1.824s (548246/s)
- 10000 sync reconnects in 2.357s (4243/s)
- 100000 async insertions in 12.496s (8003/s)
- 100000 rows sync selected in 0.713s (140252/s)
- Total time is 17.515s
Benchmarking felixge-node-mysql:
- Benchmark initialization time is 0.109s
- 1000000 escapes in 2.318s (431406/s)
- 10000 async reconnects in 9.889s (1011/s)
- 100000 async insertions in 21.33s (4688/s)
- 100000 rows async selected in 15.245s (6560/s)
- Total time is 48.893s
Benchmarking sidorares-nodejs-mysql-native:
- Benchmark initialization time is 0.07s
- 100000 async insertions in 20.175s (4957/s)
- 100000 rows async selected in 7.658s (13058/s)
- Total time is 27.908s
Benchmarking PHP-MySQL:
- Benchmark initialization time is 0,08s
- 1000000 escapes in 2,03s (491536/s)
- 10000 sync reconnects in 3,74s (2677/s)
- 100000 sync insertions in 7,78s (12861/s)
- 100000 rows sync selected in 0,9s (111315/s)
- Total time is 17.266s