Home

Sannis edited this page Oct 29, 2012 · 32 revisions
Clone this wiki locally

Results

October 29 / 2012

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

?

August 25 / 2012

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                             | -     | -         | -          | -       | -       |
+----------------------------------+-------+-----------+------------+---------+---------+

August 23 / 2012

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                             | -     | -         | -          | -       | -       |
+----------------------------------+-------+-----------+------------+---------+---------+

August 21 / 2012

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 i7-860@2.80ghz/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  |
+----------------------------------+-------+-----------+------------+---------+---------+

June 28 / 2012

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                             | -     | -       | -          | -       | -       |
+----------------------------------+-------+---------+------------+---------+---------+

May 21 / 2012

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   |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql@2.0.0-alpha                | 0.077 | 1017294 | -          | 8734    | 270270  |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql@2.0.0-preview              | 0.089 | 982318  | -          | 8482    | 294118  |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-libmysqlclient             | 0.083 | 2028398 | 4673       | 11249   | 238095  |
+----------------------------------+-------+---------+------------+---------+---------+
| mysql-native                     | 0.109 | -       | -          | 8795    | 85470   |
+----------------------------------+-------+---------+------------+---------+---------+
| odbc                             | -     | -       | -          | -       | -       |
+----------------------------------+-------+---------+------------+---------+---------+

April 20 / 2012

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                             | -     | -       | -          | -       | -       |
+----------------------------------+-------+---------+------------+---------+---------+

March 31 / 2012

node v0.6.14
node-mysql-bindings-benchmarks v0.2.1
mysql@0.9.5
mysql-libmysqlclient@1.3.10
mysql-native@0.4.4
db-mysql@0.7.6

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)

November 30 / 2011

node v0.6.0
node-mysql-bindings-benchmarks v0.2.0
mysql@0.9.5
mysql-libmysqlclient@1.2.9
mysql-native@0.4.3
db-mysql@0.7.6

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)

October 03 / 2011

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)

November 24 / 2010

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)

November 01 / 2010

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)

September 03 / 2010

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