amcintyre99
amcintyre99
/ gist:8e6e7412d98562346f419efc8b0c008d
Last active
June 2, 2017 16:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ gist:661e2c73baa0ad354124c1284614c627
Created
June 2, 2017 20:53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ gist:6021c358b901aa98961469872e430107
Created
June 2, 2017 21:08
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ gist:f45c79b633073e367c9663247fe15c16
Last active
June 4, 2017 21:28
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ perf1.svg
Created
June 4, 2017 22:59
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amcintyre99
/ gist:600ba93e7a74beedd7af3ac0d63d3326
Last active
July 10, 2017 17:26
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ gist:55e24c6fc9d0964dbec63d0bbe26904e
Last active
July 20, 2017 02:57
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ 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
/ gist:f2be210098ac9379298789fe66b80244
Last active
September 30, 2017 13:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| best of 10 runs | |
| linux gov set to performance so lowest/highest runs in each set have only 4% diff | |
| node 821 =================== | |
| ibm_db 210 at #293/#295 fix | |
| 100000 queries issued in 26.901 seconds, 3717/sec : Prepare - ExecuteNonQuery | |
| ibm_db 221 | |
| 100000 queries issued in 26.948 seconds, 3710/sec : Prepare - ExecuteNonQuery |
amcintyre99
/ gist:e89f89d0d100ecfa6f10dc51c1c377ae
Created
May 12, 2018 20:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| commissionReport: [{"execId":"00018037.5af16a15.01.01","commission":1.018678,"currency":"USD","realizedPNL":1.7976931348623157e+308,"yield":1.7976931348623157e+308,"yieldRedemptionDate":null}] |
amcintyre99
/ gist:604d974f3eb0dc1001443dbc04a13878
Created
May 13, 2018 20:28
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 00018037.5af5a2e3.01.01 0015a6f5.00013871.5af523ea.0001 0.320257 USD 1.7976931348623157E308 null 20180511-14:53:00 0.0 1.7976931348623157E308 | |
| 00018037.5af5a2e6.01.01 0015a6f5.00013871.5af523ea.0001 4.161176 USD 1.7976931348623157E308 null 20180511-14:53:00 0.0 1.7976931348623157E308 | |
| 00012bb1.5af561e1.01.01 0015a6f5.00013871.5af523e4.0001 0.320257 USD 1.7976931348623157E308 null 20180511-14:53:00 -5.888582 1.7976931348623157E308 | |
| 00012bb1.5af561e2.01.01 0015a6f5.00013871.5af523e4.0001 0.060037 USD 1.7976931348623157E308 null 20180511-14:53:00 -5.628362 1.7976931348623157E308 | |
| 00018037.5af5a2e5.01.01 0015a6f5.00013871.5af523ea.0001 0.495147 USD 1.7976931348623157E308 null 20180511-14:53:00 0.0 1.7976931348623157E308 | |
| 00018037.5af5a2e4.01.01 0015a6f5.00013871.5af523ea.0001 0.060037 USD 1.7976931348623157E308 null 20180511-14:53:00 0.0 1.7976931348623157E308 | |
| 000180 |