Skip to Content.
Sympa Menu

freetds - RE: [freetds] slow freetds-sybase perfromance - thorough test

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Gad Hayisraeli" <gadh AT vmanage.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] slow freetds-sybase perfromance - thorough test
  • Date: Sun, 9 Feb 2003 17:03:16 +0200

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
>
>
>







Archive powered by MHonArc 2.6.24.

Top of Page