freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] slow freetds-sybase perfromance - thorough test
- From: David Owen <dowen AT midsomer.org>
- To: freetds AT lists.ibiblio.org
- Subject: RE: [freetds] slow freetds-sybase perfromance - thorough test
- Date: 11 Feb 2003 14:50:26 -0700
What ASE on Linux server are you on Gad (sorry, forgotten). Michaels
suggestions are sound and will make a huge difference. Async IO might
be another biggie. Has any other tweaking been done to either the NT or
the Linux boxes?
Actually, although I don't think that he is on this list, but Wim ten
Have (who ported ASE to Linux) reads the ASE Linux list. If there is a
serious problem he is certain to want to know about it. I too have lost
track of the thread, so again cannot remember. Are we saying that the
performance decrease is independent of which set of libraries are used?
If I am muddying already dirty waters, sorry.
dowen
On Tue, 2003-02-11 at 08:59, Michael Peppler wrote:
> On Tue, 2003-02-11 at 04:09, Gad Hayisraeli wrote:
> > i think i caused some misunderstood:
> > the LPS test for both ASE linux and windows was based on freetds client,
> > with 2048 packet size. but the maximum write
> > speed of the linux server was 36 lps, while the windows was 200 lps.
> >
> > so i think its a server problem in the linux developer edition (the ASE
> > that i installed)
> >
> > someone has a clue why ?
>
> dsync on the disk devices
> default data cache too small
>
> These two will make a lot of difference...
>
> Michael
> --
> Michael Peppler Data Migrations, Inc.
> mpeppler AT peppler.org http://www.mbay.net/~mpeppler
> Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
> long term contract positions - http://www.mbay.net/~mpeppler/resume.html
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
--
David Owen Midsomer Consultants Inc. dowen AT midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ
-
RE: [freetds] slow freetds-sybase perfromance - thorough test
, (continued)
- RE: [freetds] slow freetds-sybase perfromance - thorough test, Gad Hayisraeli, 02/09/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
Lowden, James K, 02/10/2003
- Re: [freetds] slow freetds-sybase perfromance - thorough test, Steve Langasek, 02/10/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
Lowden, James K, 02/10/2003
- RE: [freetds] slow freetds-sybase perfromance - thorough test, Michael Peppler, 02/10/2003
- RE: [freetds] slow freetds-sybase perfromance - thorough test, Lowden, James K, 02/10/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
ZIGLIO Frediano, 02/11/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
Gad Hayisraeli, 02/11/2003
- Re: [freetds] slow freetds-sybase perfromance - thorough test, Steve Langasek, 02/11/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
Michael Peppler, 02/11/2003
- RE: [freetds] slow freetds-sybase perfromance - thorough test, David Owen, 02/11/2003
-
RE: [freetds] slow freetds-sybase perfromance - thorough test,
Gad Hayisraeli, 02/11/2003
- RE: [freetds] slow freetds-sybase perfromance - thorough test, Lowden, James K, 02/11/2003
Archive powered by MHonArc 2.6.24.