blob: 9c795103a3968cf03d6753a454fe40f715d1fd4e [file] [log] [blame]
================================================================================================
Char Varchar Write Side Perf w/o Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 6923 7110 309 5.8 173.1 1.0X
write char with length 5 10528 10662 195 3.8 263.2 0.7X
write varchar with length 5 7963 8002 48 5.0 199.1 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 3493 3495 3 5.7 174.6 1.0X
write char with length 10 6256 6270 13 3.2 312.8 0.6X
write varchar with length 10 3967 4027 52 5.0 198.4 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 1760 1768 8 5.7 176.0 1.0X
write char with length 20 4651 4667 22 2.2 465.1 0.4X
write varchar with length 20 1996 2014 20 5.0 199.6 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 933 940 6 5.4 186.7 1.0X
write char with length 40 3440 3444 3 1.5 688.0 0.3X
write varchar with length 40 1061 1066 5 4.7 212.2 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 650 655 5 5.1 194.9 1.0X
write char with length 60 3038 3058 18 1.1 911.5 0.2X
write varchar with length 60 730 739 8 4.6 219.1 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 505 507 3 5.0 202.0 1.0X
write char with length 80 2792 2801 10 0.9 1116.9 0.2X
write varchar with length 80 564 577 12 4.4 225.5 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 422 427 8 4.7 210.9 1.0X
write char with length 100 2809 2814 5 0.7 1404.3 0.2X
write varchar with length 100 459 463 4 4.4 229.7 0.9X
================================================================================================
Char Varchar Write Side Perf w/ Tailing Spaces
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 5: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 5 8336 8393 75 4.8 208.4 1.0X
write char with length 5 11639 11761 189 3.4 291.0 0.7X
write varchar with length 5 12002 12096 150 3.3 300.1 0.7X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 10: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 10 4296 4303 10 4.7 214.8 1.0X
write char with length 10 6722 6775 68 3.0 336.1 0.6X
write varchar with length 10 6663 6711 76 3.0 333.2 0.6X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 20: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 20 2455 2467 19 4.1 245.5 1.0X
write char with length 20 4652 4653 1 2.1 465.2 0.5X
write varchar with length 20 4462 4464 4 2.2 446.2 0.6X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 40: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 40 1478 1481 3 3.4 295.6 1.0X
write char with length 40 3492 3496 4 1.4 698.3 0.4X
write varchar with length 40 3212 3215 3 1.6 642.3 0.5X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 60: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 60 1194 1199 7 2.8 358.2 1.0X
write char with length 60 3118 3127 11 1.1 935.3 0.4X
write varchar with length 60 2863 2869 5 1.2 859.0 0.4X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 80: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 80 1019 1030 11 2.5 407.4 1.0X
write char with length 80 2865 2867 2 0.9 1146.0 0.4X
write varchar with length 80 2656 2660 4 0.9 1062.3 0.4X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Write with length 100: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
write string with length 100 940 953 12 2.1 469.9 1.0X
write char with length 100 2765 2774 10 0.7 1382.3 0.3X
write varchar with length 100 2562 2566 6 0.8 1280.8 0.4X