/
CharVarcharBenchmark-results.txt
122 lines (104 loc) · 10.2 KB
/
CharVarcharBenchmark-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 1.8.0_312-b07 on Linux 5.11.0-1022-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 17402 18234 995 2.3 435.0 1.0X
write char with length 5 19131 19469 392 2.1 478.3 0.9X
write varchar with length 5 14614 14740 124 2.7 365.3 1.2X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 7312 7437 142 2.7 365.6 1.0X
write char with length 10 11270 11329 51 1.8 563.5 0.6X
write varchar with length 10 7385 7428 72 2.7 369.3 1.0X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 3728 3794 92 2.7 372.8 1.0X
write char with length 20 7603 7667 58 1.3 760.3 0.5X
write varchar with length 20 3778 3823 40 2.6 377.8 1.0X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 1966 1985 20 2.5 393.3 1.0X
write char with length 40 5383 5421 37 0.9 1076.7 0.4X
write varchar with length 40 2002 2026 32 2.5 400.5 1.0X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 1325 1393 59 2.5 397.6 1.0X
write char with length 60 4749 4807 54 0.7 1424.8 0.3X
write varchar with length 60 1400 1420 21 2.4 419.9 0.9X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 1096 1136 63 2.3 438.5 1.0X
write char with length 80 4449 4460 11 0.6 1779.5 0.2X
write varchar with length 80 1064 1087 21 2.3 425.7 1.0X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 827 877 43 2.4 413.7 1.0X
write char with length 100 4020 4067 78 0.5 2010.2 0.2X
write varchar with length 100 903 909 8 2.2 451.7 0.9X
================================================================================================
Char Varchar Write Side Perf w/ Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 26460 26559 89 1.5 661.5 1.0X
write char with length 5 26321 26475 134 1.5 658.0 1.0X
write varchar with length 5 26290 26521 314 1.5 657.2 1.0X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 14219 14266 69 1.4 711.0 1.0X
write char with length 10 16085 16265 177 1.2 804.3 0.9X
write varchar with length 10 16257 16396 121 1.2 812.9 0.9X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 9413 9504 132 1.1 941.3 1.0X
write char with length 20 11555 11623 67 0.9 1155.5 0.8X
write varchar with length 20 11603 11629 22 0.9 1160.3 0.8X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 6888 6951 68 0.7 1377.7 1.0X
write char with length 40 9281 9391 118 0.5 1856.3 0.7X
write varchar with length 40 9316 9393 70 0.5 1863.1 0.7X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 6051 6120 62 0.6 1815.2 1.0X
write char with length 60 8681 8720 36 0.4 2604.3 0.7X
write varchar with length 60 8485 8512 25 0.4 2545.6 0.7X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 5843 5884 47 0.4 2337.4 1.0X
write char with length 80 8044 8067 20 0.3 3217.4 0.7X
write varchar with length 80 8049 8103 48 0.3 3219.4 0.7X
OpenJDK 64-Bit Server VM 1.8.0_312-b07 on Linux 5.11.0-1022-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 5299 5321 22 0.4 2649.5 1.0X
write char with length 100 7609 7733 107 0.3 3804.5 0.7X
write varchar with length 100 7664 7741 98 0.3 3832.1 0.7X