/
CharVarcharBenchmark-jdk17-results.txt
122 lines (104 loc) · 10.3 KB
/
CharVarcharBenchmark-jdk17-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 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 10175 10258 118 3.9 254.4 1.0X
write char with length 5 13411 13726 308 3.0 335.3 0.8X
write varchar with length 5 10498 10544 78 3.8 262.5 1.0X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 4865 4932 59 4.1 243.2 1.0X
write char with length 10 8614 8702 101 2.3 430.7 0.6X
write varchar with length 10 5141 5214 66 3.9 257.0 0.9X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 2532 2566 51 3.9 253.2 1.0X
write char with length 20 6053 6186 128 1.7 605.3 0.4X
write varchar with length 20 2542 2667 134 3.9 254.2 1.0X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 1272 1332 67 3.9 254.5 1.0X
write char with length 40 4170 4282 122 1.2 833.9 0.3X
write varchar with length 40 1331 1360 34 3.8 266.2 1.0X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 909 951 37 3.7 272.8 1.0X
write char with length 60 3781 3947 144 0.9 1134.3 0.2X
write varchar with length 60 931 982 48 3.6 279.4 1.0X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 701 732 28 3.6 280.4 1.0X
write char with length 80 3771 3880 153 0.7 1508.4 0.2X
write varchar with length 80 726 740 19 3.4 290.4 1.0X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 560 619 52 3.6 280.1 1.0X
write char with length 100 3628 3726 143 0.6 1814.2 0.2X
write varchar with length 100 625 657 28 3.2 312.4 0.9X
================================================================================================
Char Varchar Write Side Perf w/ Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 15811 15937 208 2.5 395.3 1.0X
write char with length 5 18566 18700 119 2.2 464.1 0.9X
write varchar with length 5 18746 18831 108 2.1 468.7 0.8X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 9111 9126 13 2.2 455.5 1.0X
write char with length 10 11330 11421 79 1.8 566.5 0.8X
write varchar with length 10 11197 11327 140 1.8 559.8 0.8X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 5949 5960 14 1.7 594.9 1.0X
write char with length 20 7673 7781 99 1.3 767.3 0.8X
write varchar with length 20 7931 8031 107 1.3 793.1 0.8X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 4359 4394 42 1.1 871.9 1.0X
write char with length 40 6037 6148 105 0.8 1207.4 0.7X
write varchar with length 40 6143 6204 53 0.8 1228.6 0.7X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 3735 3842 129 0.9 1120.4 1.0X
write char with length 60 5160 5436 253 0.6 1548.0 0.7X
write varchar with length 60 5520 5596 126 0.6 1656.0 0.7X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 3439 3557 142 0.7 1375.5 1.0X
write char with length 80 5093 5255 160 0.5 2037.2 0.7X
write varchar with length 80 5275 5332 80 0.5 2110.1 0.7X
OpenJDK 64-Bit Server VM 17.0.1+12-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 3167 3281 99 0.6 1583.7 1.0X
write char with length 100 5174 5193 29 0.4 2587.0 0.6X
write varchar with length 100 5062 5222 171 0.4 2531.1 0.6X