FreeTDS Development Group

["Gad Hayisraeli" <gadh AT vmanage.com>]

actually, any packet size >= 1024 would do the job ...



> -----Original Message-----
> From: freetds-admin AT lists.ibiblio.org
> [mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Gad Hayisraeli
> Sent: þà 09 ôáøåàø 2003 16:52þ
> To: freetds AT lists.ibiblio.org
> Subject: RE: [freetds] slow freetds-sybase perfromance - thorough test
>
>
> finally i see HUGE speed boost, after setting packet size to 2048 in ASE 
> server and freetds client + ASE odbc driver:
>
> (i attach here also this table in gif format, in case that tabs are broken )
>
> packet size = 512 (default)
>
> client                server          network         method                
>                   time(sec.)
>       LPS
> --------      --------        -------         --------------------    
> -----------             -----
> linux         windows         yes                     odbc++ over freetds   
>           5.275                   4.92
> fastlinux     windows         yes                     odbc++ over freetds   
>           5.207                   4.99
> linux         fastlinux       yes                     odbc++ over freetds   
>           1.587                   16.38
> fastlinux     fastlinux       local           odbc++ over freetds           
>   1.570                   16.56
> windows               windows         local           odbc++ over ASE odbc  
>   0.1487                  174.8
> windows               windows         yes                     odbc++ over 
> ASE odbc    0.1529                  170
> windows               fastlinux       yes                     odbc++ over 
> ASE odbc    0.753                   34
>
> packet size = 2048
>
> client                server          network         method                
>                   time(sec.)
>       LPS
> --------      --------        -------         --------------------    
> -----------             -----
> linux         windows         yes                     odbc++ over freetds   
>           0.125                   208
> fastlinux     windows         yes                     odbc++ over freetds   
>           0.130                   200
> linux         fastlinux       yes                     odbc++ over freetds   
>           0.721                   36
> fastlinux     fastlinux       local           odbc++ over freetds           
>   0.751                   34.6
> windows               windows         local           odbc++ over ASE odbc  
>   0.1487                  174.8
> windows               windows         yes                     odbc++ over 
> ASE odbc    0.1529                  170
> windows               fastlinux       yes                     odbc++ over 
> ASE odbc    0.753                   34
>
>
> my conclusions for now:
> =======================
> increasing packet size by factor 4 (2048 bytes) caused the windows ASE to 
> boost its perfomance , especially in freetds
> (!!!) to the maximum write speed available !
>
> though, we can see that the linux ASE boosted by factor 2 (36-34 lines per 
> second) , which is a nice to have,
> but not as
> windows, so maybe the ASE linux developers still have a work to do ...
>
> do not pay attention to the paradox that local perfomance are poor than 
> network performance.
> like i said before, there could be changes in 10% range, so measuring 
> network  results is not accurate more than that.
>
> so we can see , if i'm not wrong, that its not a matter of an odbc client , 
> but of an ASE
> server.
>
> maybe a new topic:
> ====================
> i did my tests on local network, so i can choose large packet sizes , but 
> if the ASE is on another lan/wan network,
> could i choose the same size, although the tcp packet size is less than 
> local network ? (indeed i chose 2048 on local
> net, where the default tcp packet size is 1500 ...)
>
>
> Gad
>
>
>