WebSQL Server - Benchmarks

Benchmarks

Investment Club Benchmark  |  Compare with TCP-E

Configuration:
Operating System : Windows Server 2012 R2 Datacenter
Compiler : Visual C++ 180031101

Columns:
TPS : transactions per second
$/Month : total charges associated with using cloud resources per month
$/TPS : price/performance based on 3-Yr cost of ownership

TPS $/Month $/TPS Cloud VM CPU Type Cores Database Date Details
38,346.826 $582.68 $0.54 AWS c4.2xlarge Intel Xeon E5-2666 v3 (2.90 GHz) 8 - 6/18/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit0.1340.5092.869---100,000
Withdraw0.1310.4972.761---100,000
Stock Offer0.1340.4972.968---200,000
Vote0.1330.5023.037---200,000
Buy Order0.1340.5052.810---100,000
Sell Order0.1330.5002.959---100,000
Price Update0.0020.0030.056---100,000
Total 900,000
Measurement Interval (seconds) 23.470
Throughput (transactions per second) 38,346.826
32,535.608 $1,943.00 $2.15 Azure D14 Intel Xeon E5-2660 (2.20 GHz) 16 - 6/6/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit0.1220.3148.780---100,000
Withdraw0.1210.3084.904---100,000
Stock Offer0.1280.3194.921---200,000
Vote0.1240.3137.688---200,000
Buy Order0.1250.3146.535---100,000
Sell Order0.1210.3078.567---100,000
Price Update0.0050.0052.026---100,000
Total 900,000
Measurement Interval (seconds) 27.662
Throughput (transactions per second) 32,535.608
18,838.304 $536.00 $1.02 Azure A4 Intel Xeon E5-2660 (2.20 GHz) 8 - 5/24/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 0.090 0.231 9.011 - - - 100,000
Withdraw 0.086 0.223 8.993 - - - 100,000
Stock Offer 0.093 0.233 12.533 - - - 200,000
Vote 0.090 0.230 12.456 - - - 200,000
Buy Order 0.089 0.226 9.502 - - - 100,000
Sell Order 0.088 0.225 8.555 - - - 100,000
Price Update 0.004 0.004 3.935 - - - 100,000
Total 900,000
Measurement Interval (seconds) 47.775
Throughput (transactions per second) 18,838.304
13,851.907 $536.00 $1.39 Azure A4 AMD Opteron 4171 HE (2.1 GHz) 8 - 5/12/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 0.099 0.242 7.731 - - - 100,000
Withdraw 0.099 0.246 5.898 - - - 100,000
Stock Offer 0.113 0.260 6.431 - - - 200,000
Vote 0.108 0.253 8.981 - - - 200,000
Buy Order 0.109 0.254 8.005 - - - 100,000
Sell Order 0.101 0.248 7.859 - - - 100,000
Price Update 0.012 0.019 3.670 - - - 100,000
Total 900,000
Measurement Interval (seconds) 64.973
Throughput (transactions per second) 13,851.907
5,672.078 $67.00 $0.42 Azure A1 Intel Xeon E5-2660 (2.20 GHz) 1 - 5/24/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 0.429 0.402 171.241 - - - 100,000
Withdraw 0.408 0.393 60.402 - - - 100,000
Stock Offer 0.429 0.401 204.885 - - - 200,000
Vote 0.433 0.406 90.262 - - - 200,000
Buy Order 0.458 0.409 121.645 - - - 100,000
Sell Order 0.453 0.409 184.394 - - - 100,000
Price Update 0.005 0.004 4.531 - - - 100,000
Total 900,000
Measurement Interval (seconds) 158.672
Throughput (transactions per second) 5,672.078
4,894.204 $2,949.79 $21.69 AWS c4.2xlarge Intel Xeon E5-2666 v3 (2.90 GHz) 8 DynamoDB 6/18/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit5.3537.2971016.8805.2857.2291016.818100,000
Withdraw5.3437.3031021.2425.2767.2361021.177100,000
Stock Offer5.9737.933673.4175.9037.862673.351200,000
Vote6.7718.697653.3376.7028.629653.269200,000
Buy Order6.5328.357659.3946.4638.289659.331100,000
Sell Order5.3657.216680.0875.2977.149680.024100,000
Price Update6.6638.452511.0856.6188.409511.043100,000
Total 900,000
Measurement Interval (seconds) 183.891
Throughput (transactions per second) 4,894.204
4,288.103 $2.343.13 $19.67 Azure D14 Intel Xeon E5-2660 (2.20 GHz) 16 Table Storage 6/6/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit12.09515.5721746.06412.00115.4621745.985100,000
Withdraw14.12919.8221719.66114.03519.7221719.588100,000
Stock Offer15.23119.910667.40115.11319.790667.227200,000
Vote13.23618.188938.04513.12218.065937.940200,000
Buy Order15.58920.235682.87815.46520.111682.640100,000
Sell Order15.41520.454664.74215.31020.336664.573100,000
Price Update14.54019.3681748.93014.47919.3081748.876100,000
Total 900,000
Measurement Interval (seconds) 209.883
Throughput (transactions per second) 4,288.103
3,107.756 $4,256.00 $49.30 Azure A4 AMD Opteron 4171 HE (2.1 GHz) 8 SQL Database P3 5/12/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 3.815 5.873 69.050 3.226 5.182 65.770 100,000
Withdraw 3.843 5.903 66.273 3.248 5.204 58.272 100,000
Stock Offer 8.472 11.105 96.019 4.370 5.696 46.929 200,000
Vote 3.827 5.874 65.802 3.227 5.173 60.660 200,000
Buy Order 5.857 8.172 86.572 1.708 2.728 40.606 100,000
Sell Order 5.847 8.182 64.727 1.706 2.722 46.642 100,000
Price Update 4.495 7.302 54.070 4.459 7.262 54.019 100,000
Total 900,000
Measurement Interval (seconds) 289.598
Throughput (transactions per second) 3,107.756
3,046.788 $820.30 $9.69 Azure A4 Intel Xeon E5-2660 (2.20 GHz) 8 Table Storage 5/24/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 9.684 12.586 279.313 9.604 12.501 279.251 100,000
Withdraw 10.811 14.167 221.007 10.734 14.087 220.935 100,000
Stock Offer 9.668 10.942 273.456 9.584 10.854 273.390 200,000
Vote 9.729 11.474 878.215 9.647 11.391 877.970 200,000
Buy Order 9.964 11.248 322.623 9.875 11.152 322.430 100,000
Sell Order 9.963 11.235 383.472 9.877 11.153 383.396 100,000
Price Update 10.041 11.153 311.346 9.993 11.103 311.301 100,000
Total 900,000
Measurement Interval (seconds) 295.393
Throughput (transactions per second) 3,046.788
1,853.801 $239.98 $4.66 Azure A1 Intel Xeon E5-2660 (2.20 GHz) 1 Table Storage 5/24/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit 12.646 17.285 394.329 11.635 16.198 389.443 100,000
Withdraw 13.407 17.754 387.749 12.377 16.733 387.252 100,000
Stock Offer 12.714 16.815 390.570 11.680 15.295 389.995 200,000
Vote 12.240 16.462 398.555 11.216 14.104 397.584 200,000
Buy Order 12.727 16.764 356.543 11.643 15.054 355.851 100,000
Sell Order 12.678 16.730 359.621 11.612 15.035 359.275 100,000
Price Update 11.290 15.863 270.630 11.208 15.692 270.561 100,000
Total 900,000
Measurement Interval (seconds) 485.489
Throughput (transactions per second) 1,853.801
1,364.825 $2.343.00 $61.80 Azure D14 Intel Xeon E5-2660 (2.20 GHz) 16 DocumentDB S3*4 6/6/2015
Transaction Total (in milliseconds) Database (in milliseconds) Count
Average 90%tile Maximum Average 90%tile Maximum
Deposit45.92858.670660.64245.78358.524660.465100,000
Withdraw45.65058.239694.30545.50558.097694.219100,000
Stock Offer45.80458.504261.74145.62558.328261.581200,000
Vote45.62658.123598.45745.45957.960598.253200,000
Buy Order45.94458.353228.20945.77058.183228.064100,000
Sell Order45.91458.302220.83145.76258.151220.682100,000
Price Update45.93858.807636.12545.87158.740636.060100,000
Total 900,000
Measurement Interval (seconds) 659.425
Throughput (transactions per second) 1,364.825

See Also:

Table of Contents