FET_BUF_SIZE: default [4096] Load Trans Run TPS Avg Trans Time Time 1 5 106570 300 355.233 0.002815 1 10 170189 300 568.297 0.001763 1 20 300241 300 1000.803 0.000999 1 30 463816 300 1546.053 0.000647 FET_BUF_SIZE: 8192 Load Trans Run TPS Avg Trans Time Time 1 5 119371 300 397.903 0.002513 1 10 197025 300 656.750 0.001523 1 20 310963 300 1036.543 0.000965 1 30 418661 300 1395.537 0.000717 FET_BUF_SIZE: 32768 Load Trans Run TPS Avg Trans Time Time 1 5 94385 300 314.617 0.003178 1 10 181799 300 605.997 0.001650 1 20 327854 300 1092.847 0.000915 1 30 426776 300 1422.587 0.000703
Packet analysis shows that majority of the benchmark toolkit SQLs need just 1 tcp packets, so maxi'ing out the fet_buf_size makes things slower.
There is a developersWorks article available.
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.