amcintyre99

$ node -v
v6.11.1
$ node prep_execsync_orig.js 
[ { '1': '22:55:28' } ] 0
[ { '1': '22:55:28' } ] 1
[ { '1': '22:55:28' } ] 2
[ { '1': '22:55:28' } ] 3
..
[ { '1': '22:55:28' } ] 185
[ { '1': '22:55:28' } ] 186

amcintyre99

best of 10 runs
linux gov set to performance

ibm_db 2.1

node 4.8.3
100000 queries issued in 14.036 seconds, 7124/sec : Prepare - ExecuteNonQuery

node 6.11.0
100000 queries issued in 37.527 seconds, 2664/sec : Prepare - ExecuteNonQuery

amcintyre99

amcintyre99

andrew@sherlock:~/dma/odbc_ibm$ node -v
v6.10.3
andrew@sherlock:~/dma/odbc_ibm$ node db2-bench-prepare-executeNonQuery.js 
100000 queries issued in 39.69 seconds, 2519/sec : Prepare - ExecuteNonQuery 
connection closed
andrew@sherlock:~/dma/odbc_ibm$ perf record -F 9999 -g node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 46.891 seconds, 2132/sec : Prepare - ExecuteNonQuery 
connection closed
[ perf record: Woken up 405 times to write data ]
[ perf record: Captured and wrote 101.781 MB perf.data (489498 samples) ]

amcintyre99

andrew@sherlock:~/dma/odbc_ibm$ node -v
v6.10.3
andrew@sherlock:~/dma/odbc_ibm$ node --prof db2-bench-prepare-executeNonQuery.js 
100000 queries issued in 39.262 seconds, 2546/sec : Prepare - ExecuteNonQuery 
connection closed
andrew@sherlock:~/dma/odbc_ibm$ ls -rtl
total 3100
-rw-r--r--  1 andrew andrew    1037 Jul  2  2016 commons.js
-rw-r--r--  1 andrew andrew     826 Jul  2  2016 db2-test-prepare.js
-rw-r--r--  1 andrew andrew    1044 May 30 23:51 db2-bench-prepare-executeNonQuery.js

amcintyre99

andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.545 seconds, 2195/sec : Prepare - ExecuteNonQuery 
connection closed
[ perf record: Woken up 44 times to write data ]
[ perf record: Captured and wrote 11.859 MB perf.data (306174 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#
#
# Total Lost Samples: 0

amcintyre99

andrew@sherlock:~/dma/odbc_ibm$ node -v
v6.10.3
andrew@sherlock:~/dma/odbc_ibm$ node db2-bench-prepare-executeNonQuery.js 
100000 queries issued in 38.269 seconds, 2613/sec : Prepare - ExecuteNonQuery 
connection closed
andrew@sherlock:~/dma/odbc_ibm$ sysctl kernel.kptr_restrict
kernel.kptr_restrict = 0
andrew@sherlock:~/dma/odbc_ibm$ perf record -g node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.922 seconds, 2177/sec : Prepare - ExecuteNonQuery 
connection closed

amcintyre99

node 4.8.3

andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 20.666 seconds, 4838/sec : Prepare - ExecuteNonQuery 
connection closed
[ perf record: Woken up 35 times to write data ]
[ perf record: Captured and wrote 9.556 MB perf.data (244959 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#

amcintyre99

node 6.10.3

andrew@sherlock:~/dma/odbc_ibm$ perf record node --perf-basic-prof db2-bench-prepare-executeNonQuery.js
100000 queries issued in 45.665 seconds, 2189/sec : Prepare - ExecuteNonQuery 
connection closed
[ perf record: Woken up 41 times to write data ]
[ perf record: Captured and wrote 10.490 MB perf.data (273571 samples) ]
andrew@sherlock:~/dma/odbc_ibm$ perf report --stdio
# To display the perf.data header info, please use --header/--header-only options.
#

amcintyre99

andrew@sherlock:~/dma/odbc_ibm$ node --prof db2-bench-prepare-executeNonQuery.js 
100000 queries issued in 39.429 seconds, 2536/sec : Prepare - ExecuteNonQuery 
connection closed
andrew@sherlock:~/dma/odbc_ibm$ ls -rtl
total 3124
-rw-r--r--  1 andrew andrew    1037 Jul  2  2016 commons.js
-rw-r--r--  1 andrew andrew     826 Jul  2  2016 db2-test-prepare.js
drwxrwxr-x 98 andrew andrew    4096 May 28 21:52 node_modules
-rw-r--r--  1 andrew andrew    1044 May 30 23:51 db2-bench-prepare-executeNonQuery.js
-rw-rw-r--  1 andrew andrew 3182236 May 31 14:04 isolate-0x3746270-v8.log