blob: 81fde75513bc478105dc51e2552d5a68d3da4319 [file] [log] [blame]
================================================================================================
Char Varchar Write Side Perf w/o Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 7857 7995 157 5.1 196.4 1.0X
write char with length 5 10444 10504 68 3.8 261.1 0.8X
write varchar with length 5 8343 8377 30 4.8 208.6 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 3826 3841 24 5.2 191.3 1.0X
write char with length 10 6886 6895 14 2.9 344.3 0.6X
write varchar with length 10 4180 4192 11 4.8 209.0 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 1951 1957 9 5.1 195.1 1.0X
write char with length 20 4865 4867 2 2.1 486.5 0.4X
write varchar with length 20 1982 2047 57 5.0 198.2 1.0X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 1004 1005 2 5.0 200.8 1.0X
write char with length 40 3618 3631 23 1.4 723.6 0.3X
write varchar with length 40 1071 1076 9 4.7 214.2 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 667 672 7 5.0 200.2 1.0X
write char with length 60 3204 3245 36 1.0 961.2 0.2X
write varchar with length 60 745 752 12 4.5 223.4 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 514 517 4 4.9 205.6 1.0X
write char with length 80 3079 3082 4 0.8 1231.8 0.2X
write varchar with length 80 585 592 12 4.3 233.9 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 437 440 3 4.6 218.6 1.0X
write char with length 100 2973 2980 6 0.7 1486.4 0.1X
write varchar with length 100 453 461 8 4.4 226.4 1.0X
================================================================================================
Char Varchar Write Side Perf w/ Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 8765 8777 13 4.6 219.1 1.0X
write char with length 5 11726 11732 6 3.4 293.1 0.7X
write varchar with length 5 12344 12357 14 3.2 308.6 0.7X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 4874 4879 5 4.1 243.7 1.0X
write char with length 10 7466 7469 4 2.7 373.3 0.7X
write varchar with length 10 7653 7683 27 2.6 382.7 0.6X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 2620 2625 4 3.8 262.0 1.0X
write char with length 20 4823 4828 4 2.1 482.3 0.5X
write varchar with length 20 5117 5118 1 2.0 511.7 0.5X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 1558 1562 6 3.2 311.6 1.0X
write char with length 40 3722 3727 5 1.3 744.4 0.4X
write varchar with length 40 3880 3882 5 1.3 775.9 0.4X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 1298 1306 6 2.6 389.5 1.0X
write char with length 60 3351 3356 4 1.0 1005.3 0.4X
write varchar with length 60 3454 3462 8 1.0 1036.1 0.4X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 1081 1092 9 2.3 432.5 1.0X
write char with length 80 3272 3278 5 0.8 1308.9 0.3X
write varchar with length 80 3277 3284 8 0.8 1311.0 0.3X
OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 1007 1014 6 2.0 503.7 1.0X
write char with length 100 3160 3169 7 0.6 1580.1 0.3X
write varchar with length 100 3135 3150 12 0.6 1567.7 0.3X