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: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] slow freetds-sybase perfromance - thorough test
  • Date: Tue, 11 Feb 2003 11:09:35 +0100

>
> > 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 ...
>
> i request please your attention to what i wrote before:
> how can you explain the performance decrease between linux
> and windows ASE servers ?
> (200 --> 36 LPS)
>

Only for packet difference ??
I don't know. FreeTDS approch is to fill all buffer until packet and then
send it. Perhaps a best approch would be to cache even multiple packet and
send together... I have also some idea for improving write speed locally
(using some more space and simpler pointer instead of calling a function for
every write...)
Or perhaps problem is somewhere else. Some numeric conversions are very slow
(400 against 100000...). Perhaps when we use 512 byte packet, and more than
13/14 fields with many numeric (as your example) those conversions are more
taken into account... James are working on this conversions to improve
performance.
Another problem is prepared statement. Although this area have seen some
improvements in 0.61 there are more works to do. This will avoid many
conversions and save some networks band (and some server work too).

Personally I'm very busy at the moment so I have few time to make test on my
own... Quite all the time I spent on FreeTDS nowadays is reading mail...

Finally I want to thanks you for all yours patience and feedback.

Regards
Frediano Ziglio

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page