Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact

Oninit BenchIt Toolkit: FET_BUFSIZE

Informix 11.7.FC5

 

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.