Last active
August 31, 2024 18:15
-
-
Save worksofliam/16887750d6b52c9ba241070a7d7068b4 to your computer and use it in GitHub Desktop.
Node.js ODBC v Mapepire performance
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
| > start | |
| > node --env-file=.env index.js odbc p 50 | |
| Running.. | |
| --------------------------------- | |
| node-odbc - Pool-Promise.all - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: -362.588875ms | |
| Total queries: 50 | |
| Total time: 128799.41846100001ms | |
| Average time: 2575.98836922ms | |
| Fastest query: 676.6542079999999ms (query 2) | |
| Slowest query: 4017.671917ms (query 50) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 676.8038330000002 676.6542079999999 1006.4209999999999 1006.5040000000001 1006.688959 1575.0858329999999 1575.403209 1575.556417 1575.712958 1796.1922499999998 1805.1747079999998 1805.927708 1803.0073750000001 2123.61875 2030.503083 2024.123375 2030.2811669999999 2244.786625 2278.523 2278.3660419999997 2357.553208 2469.122375 2511.7407909999997 2509.455958 2590.0545829999996 2684.899708 2748.036417 2747.683458 2829.05925 2908.4873749999997 2980.459792 2974.61125 3058.895209 3133.8184579999997 3193.399625 3196.01425 3279.4905 3354.93025 3424.481917 3416.605917 3494.562042 3575.0292080000004 3633.615167 3641.187292 3717.239292 3795.084292 3853.6019589999996 3872.5335840000002 3934.7589169999997 4017.671917 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js mapepire p 50 | |
| Running.. | |
| --------------------------------- | |
| Mapepire - Pool-Promise.all - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: -1040.171416ms | |
| Total queries: 50 | |
| Total time: 15997.946251999998ms | |
| Average time: 319.95892503999994ms | |
| Fastest query: 311.3249169999999ms (query 20) | |
| Slowest query: 328.9485830000001ms (query 5) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 312.88537500000007 312.682959 314.36291600000004 321.40758299999993 328.9485830000001 328.64883399999985 328.806458 318.1969590000001 327.2715830000002 323.4711659999998 315.090917 327.03079100000014 319.3827919999999 317.48333300000013 322.652875 322.94883400000003 317.54825000000005 313.78225 311.47962499999994 311.3249169999999 328.14137500000015 327.714375 327.30212499999993 313.77700000000004 322.41704200000004 317.003833 319.88587499999994 318.33945800000015 326.0101669999999 317.02604199999996 326.07445900000016 312.97400000000016 326.251125 313.28412500000013 326.23512500000015 327.39258399999994 318.5485840000001 319.72129199999995 321.8697910000001 314.3498749999999 321.7645 318.02433299999984 319.31158400000004 312.554625 318.01258299999995 318.02649999999994 313.8567499999999 326.07004199999983 316.75737500000014 313.8427079999999 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js odbc pa 50 | |
| Running.. | |
| --------------------------------- | |
| node-odbc - Pool-For-Await - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: -333.477292ms | |
| Total queries: 50 | |
| Total time: 11990.810878999993ms | |
| Average time: 239.81621757999986ms | |
| Fastest query: 211.4142499999998ms (query 15) | |
| Slowest query: 624.0224579999999ms (query 1) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 624.0224579999999 314.45829200000003 327.01379199999997 230.04624999999987 226.1589580000002 231.87662500000033 234.99333400000023 529.7042920000004 238.38716700000032 225.38129200000003 215.23404100000016 221.78995799999984 226.70516700000007 229.2256670000006 211.4142499999998 218.16445899999962 219.5307499999999 216.31562500000018 220.25012500000048 216.17958399999952 220.7713329999997 234.12095899999986 222.16916700000002 215.84520799999973 218.4694580000005 217.68629200000032 218.06733299999996 216.71450000000004 213.95524999999998 221.91883400000006 218.19941599999947 218.9710410000007 217.94716599999992 224.4872919999998 213.47662499999933 246.80216699999983 223.32437499999833 219.81725000000006 232.9874579999996 217.76770899999974 212.22108300000036 216.15612499999952 218.95204199999898 219.61283299999923 217.8068749999984 214.25229199999922 224.72120900000118 212.2862499999992 214.3052919999991 230.1459589999995 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js mapepire pa 50 | |
| Running.. | |
| --------------------------------- | |
| Mapepire - Pool-For-Await - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: -766.83875ms | |
| Total queries: 50 | |
| Total time: 4402.323956999997ms | |
| Average time: 88.04647913999993ms | |
| Fastest query: 72.14574999999968ms (query 49) | |
| Slowest query: 369.8667499999997ms (query 23) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 265.1450000000001 77.94241699999998 76.15533299999993 79.44925000000012 79.79929200000015 82.11737500000004 76.66216699999995 76.5787499999999 78.58904200000006 76.602709 75.28791699999988 79.76479100000006 85.87299999999982 76.17275000000018 80.39975000000004 78.35449999999992 85.4144580000002 82.19204199999967 72.713209 75.72612499999968 82.10941599999978 77.99224999999979 369.8667499999997 77.23504099999991 76.5141249999997 78.76012499999979 80.64633300000014 77.35754199999974 77.15070800000012 76.53212500000018 77.89033300000028 76.16491700000006 76.20004100000006 77.14170899999999 79.08391699999993 76.03408299999955 77.36929099999998 79.3032089999997 78.59437499999967 77.63650000000052 78.26233300000058 74.26029199999994 77.66962499999954 82.89845799999966 75.36041599999953 98.13462499999969 76.41829200000029 75.7930409999999 72.14574999999968 80.8584579999997 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js odbc s 50 | |
| Running.. | |
| --------------------------------- | |
| node-odbc - Single-Promise.all - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: 357.49312499999996ms | |
| Total queries: 50 | |
| Total time: 405042.87866700004ms | |
| Average time: 8100.857573340001ms | |
| Fastest query: 1263.8029999999999ms (query 1) | |
| Slowest query: 12949.154708ms (query 50) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 1263.8029999999999 1415.6505 1713.8162079999997 2008.8068340000002 2387.2657919999997 3235.660833 3686.414875 3525.780209 3834.725875 4056.092916 4377.021 4306.602916 4743.339542 5860.995792 5340.435459 5631.441583000001 5861.368667000001 5861.616292000001 5861.821666 5862.036499999999 6669.0016669999995 6669.24 6669.429375 7585.697916 8025.860833000001 8242.007207999999 8760.873083 8980.698792000001 9343.513834 9717.937875 9942.466208 9943.003208 11075.4 10335.241417000001 11448.664583000002 11819.964875 11602.062042 12256.552625 12942.203666000001 12941.538333999999 12721.221708000001 12942.362125000001 12942.874542000001 12942.537708000002 12942.690375 12948.888459 12948.966792 12949.096375 12949.031875 12949.154708 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js mapepire s 50 | |
| Running.. | |
| --------------------------------- | |
| Mapepire - Single-Promise.all - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: 699.363083ms | |
| Total queries: 50 | |
| Total time: 16395.252918ms | |
| Average time: 327.90505835999994ms | |
| Fastest query: 315.6071249999999ms (query 1) | |
| Slowest query: 334.5943750000001ms (query 12) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 315.6071249999999 325.991625 326.1828750000001 329.82550000000003 328.96683299999995 328.0037500000001 330.11804199999995 321.86312499999997 323.22875 327.7058750000001 321.64541699999995 334.5943750000001 328.819083 321.52095900000006 325.41429199999993 331.3770830000001 323.54116599999986 334.46629200000007 333.214875 328.39204099999995 321.1996250000001 331.63025000000005 327.4354169999999 333.78874999999994 322.836084 333.9067500000001 324.8420000000001 329.227584 329.4569999999999 333.9463750000001 320.702084 331.4226249999999 331.1455410000001 329.2627080000001 331.06545900000003 331.558625 325.25475000000006 323.30270800000005 333.0344170000001 328.07737499999996 323.003375 329.52987500000006 333.711583 331.16600000000005 324.9512500000001 322.789667 327.01812500000005 328.9669160000001 331.19887499999993 329.342042 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js odbc sa 50 | |
| Running.. | |
| --------------------------------- | |
| node-odbc - Single-For-Await - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: 346.9355ms | |
| Total queries: 50 | |
| Total time: 12027.640169000002ms | |
| Average time: 240.55280338000003ms | |
| Fastest query: 209.1799579999988ms (query 35) | |
| Slowest query: 520.167042ms (query 21) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 302.84487499999994 229.64591700000005 242.966458 223.35066699999993 217.94720800000005 506.90816700000005 217.747167 230.737709 221.91354200000023 226.7864169999998 242.67662500000006 240.8082089999998 224.2022079999997 213.62191699999994 221.57899999999972 236.71745900000042 231.70995799999946 218.78487500000028 211.0727080000006 216.67070799999965 520.167042 237.41533299999992 220.51920900000005 216.59704200000033 219.30249999999978 220.93945799999983 226.06520799999998 288.9215000000004 222.5089170000001 215.10249999999996 218.5765420000007 222.5291670000006 219.37104200000067 217.8888330000009 209.1799579999988 214.25124999999935 218.05287500000122 218.13558299999931 217.5550830000011 217.94929199999933 302.09620800000084 230.23175000000083 223.94574999999895 220.58399999999892 229.34358299999985 292.43325000000004 228.8351249999996 222.37687499999993 221.5892500000009 216.48424999999952 | |
| --------------------------------- | |
| > start | |
| > node --env-file=.env index.js mapepire sa 50 | |
| Running.. | |
| --------------------------------- | |
| Mapepire - Single-For-Await - 50 queries | |
| Node.js version: v20.14.0 | |
| Platform: darwin | |
| Architecture: arm64 | |
| SQL used: | |
| SELECT * FROM SAMPLE.DEPARTMENT | |
| Pool startup: | |
| Start size: 5 | |
| Max size: 5 | |
| Time: 718.5559169999999ms | |
| Total queries: 50 | |
| Total time: 4345.022626000001ms | |
| Average time: 86.90045252000002ms | |
| Fastest query: 71.78787499999999ms (query 25) | |
| Slowest query: 257.75ms (query 1) | |
| Keynote chart: | |
| 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | |
| 257.75 75.98416599999996 72.27929099999983 79.40525000000002 80.47499999999991 75.66987499999982 79.58112499999993 114.881666 84.59866699999998 77.42116699999997 74.409625 82.43516699999986 76.94954200000006 76.22025000000008 136.6070840000002 76.45166700000027 77.87379200000032 76.18654199999992 166.31391699999995 81.85116700000026 76.34854099999984 78.77625000000035 112.14304099999981 72.89879199999996 71.78787499999999 76.44083300000011 76.7768329999999 113.26541700000007 78.48933299999999 79.66770900000029 78.86412500000006 75.41170800000009 76.73520800000006 76.11929199999986 73.52016699999967 77.77666700000009 77.6797919999999 74.61058400000002 73.99570799999947 73.84004199999981 80.42100000000028 77.33829100000003 108.04237499999999 85.54199999999946 76.75575000000026 78.21645799999988 79.98720800000046 80.44579200000044 79.7133330000006 80.06754199999978 | |
| --------------------------------- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment