-
Notifications
You must be signed in to change notification settings - Fork 28k
/
CharVarcharBenchmark-jdk11-results.txt
122 lines (104 loc) · 10.2 KB
/
CharVarcharBenchmark-jdk11-results.txt
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
================================================================================================
Char Varchar Write Side Perf w/o Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 13619 13854 242 2.9 340.5 1.0X
write char with length 5 19804 20038 207 2.0 495.1 0.7X
write varchar with length 5 14221 14375 262 2.8 355.5 1.0X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 6453 6581 120 3.1 322.6 1.0X
write char with length 10 11722 11991 278 1.7 586.1 0.6X
write varchar with length 10 6903 6951 58 2.9 345.1 0.9X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 3412 3525 98 2.9 341.2 1.0X
write char with length 20 7987 8172 186 1.3 798.7 0.4X
write varchar with length 20 3499 3583 81 2.9 349.9 1.0X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 1735 1780 46 2.9 347.0 1.0X
write char with length 40 6339 6403 103 0.8 1267.7 0.3X
write varchar with length 40 1896 1970 64 2.6 379.2 0.9X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 1251 1286 52 2.7 375.3 1.0X
write char with length 60 5806 5877 62 0.6 1741.8 0.2X
write varchar with length 60 1295 1320 24 2.6 388.5 1.0X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 942 973 26 2.7 376.9 1.0X
write char with length 80 5390 5544 135 0.5 2156.1 0.2X
write varchar with length 80 1066 1079 13 2.3 426.3 0.9X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 826 842 18 2.4 413.1 1.0X
write char with length 100 5100 5156 49 0.4 2549.8 0.2X
write varchar with length 100 851 870 17 2.3 425.6 1.0X
================================================================================================
Char Varchar Write Side Perf w/ Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 23188 23357 273 1.7 579.7 1.0X
write char with length 5 25759 26065 278 1.6 644.0 0.9X
write varchar with length 5 25672 26080 362 1.6 641.8 0.9X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 12930 13181 227 1.5 646.5 1.0X
write char with length 10 15199 15739 548 1.3 759.9 0.9X
write varchar with length 10 16046 16095 81 1.2 802.3 0.8X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 9147 9198 48 1.1 914.7 1.0X
write char with length 20 11226 11324 87 0.9 1122.6 0.8X
write varchar with length 20 11574 11652 74 0.9 1157.4 0.8X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 6600 6698 91 0.8 1320.0 1.0X
write char with length 40 8835 9184 304 0.6 1767.0 0.7X
write varchar with length 40 9211 9300 79 0.5 1842.3 0.7X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 5499 5606 134 0.6 1649.8 1.0X
write char with length 60 7934 8048 192 0.4 2380.2 0.7X
write varchar with length 60 7886 8003 122 0.4 2365.9 0.7X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 5520 5554 40 0.5 2207.9 1.0X
write char with length 80 7619 7690 98 0.3 3047.6 0.7X
write varchar with length 80 7679 7771 80 0.3 3071.5 0.7X
OpenJDK 64-Bit Server VM 11.0.18+10 on Linux 5.15.0-1031-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 4972 5083 115 0.4 2486.2 1.0X
write char with length 100 7197 7333 118 0.3 3598.6 0.7X
write varchar with length 100 7121 7237 135 0.3 3560.5 0.7X