Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

-ca 0 parameter: ODBC speed issues

3 posts in General Discussion Last posting was on 2009-08-26 13:56:37.0Z
Bjoern Wesolowski Posted on 2009-08-26 12:51:13.0Z
Reply-To: "Bjoern Wesolowski" <none>
From: "Bjoern Wesolowski" <none>
Newsgroups: ianywhere.public.general
Subject: -ca 0 parameter: ODBC speed issues
Lines: 15
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a952fc1@forums-1-dub>
Date: 26 Aug 2009 05:51:13 -0700
X-Trace: forums-1-dub 1251291073 10.22.241.152 (26 Aug 2009 05:51:13 -0700)
X-Original-Trace: 26 Aug 2009 05:51:13 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7695
Article PK: 6083

Dear all,

I experienced a strange speed issue when connecting to my SQL Anywhere 10
database server via ODBC. When the database server is started with the -ca 0
parameter the connection speed turns out to be very slow but when I don't
use this parameter the speed is like a rocket.

Do you have any explanation / reason for this?

I run SQL Anywhere 10.0.1.3750.

Thanks & with best regards,

Björn


Volker Barth <No_VBarth Posted on 2009-08-26 13:25:56.0Z
From: Volker Barth <No_VBarth@Spam_GLOBAL-FINANZ.de>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: -ca 0 parameter: ODBC speed issues
References: <4a952fc1@forums-1-dub>
In-Reply-To: <4a952fc1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9537e4$1@forums-1-dub>
Date: 26 Aug 2009 06:25:56 -0700
X-Trace: forums-1-dub 1251293156 10.22.241.152 (26 Aug 2009 06:25:56 -0700)
X-Original-Trace: 26 Aug 2009 06:25:56 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7696
Article PK: 6737

What's your complete server command line?
Does it include other -c parameters?
If not, I would think that
a) if "-c ..." is missing, SA 10 uses a default cache of 2 MB on most
platforms and
b) then -ca 0 will force the server not to increment the cache size,
resulting in a very small cache. That would explain VERY poor performance.

If the above is correct and you omit the "-ca 0", the server will adjust
cache size as needed, and without any -c... options the cache might
reach most of the available physical RAM - that will be much larger then
2 MB of modern hardware.

Is there any reason why you want to use "-ca 0"?

HTH
Volker

Bjoern Wesolowski wrote:
> Dear all,
>
> I experienced a strange speed issue when connecting to my SQL Anywhere
> 10 database server via ODBC. When the database server is started with
> the -ca 0 parameter the connection speed turns out to be very slow but
> when I don't use this parameter the speed is like a rocket.
>
> Do you have any explanation / reason for this?
>
> I run SQL Anywhere 10.0.1.3750.
>
> Thanks & with best regards,
>
> Björn


John Smirnios [Sybase] Posted on 2009-08-26 13:56:37.0Z
From: "John Smirnios [Sybase]" <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: -ca 0 parameter: ODBC speed issues
References: <4a952fc1@forums-1-dub>
In-Reply-To: <4a952fc1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a953f15$1@forums-1-dub>
Date: 26 Aug 2009 06:56:37 -0700
X-Trace: forums-1-dub 1251294997 10.22.241.152 (26 Aug 2009 06:56:37 -0700)
X-Original-Trace: 26 Aug 2009 06:56:37 -0700, vip152.sybase.com
Lines: 38
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7697
Article PK: 6739

First, what exactly do you mean by "connection speed"? The time to
establish a connection or the time to execute requests on the
connection? If it is the time to establish a connection, I can't imagine
how -ca 0 could affect it any way.

In addition to what Volker suggested, you might try adding the -cs
switch (cache sizing stats) and capture the server output with "-o
filename". Look for messages showing how the cache size was adjusted and
the stats info (Worker set size, etc). Do this with and without -ca 0
and post the messages here. Please include the startup message showing
the min, initial, and max cache sizes.


-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Bjoern Wesolowski wrote:
> Dear all,
>
> I experienced a strange speed issue when connecting to my SQL Anywhere
> 10 database server via ODBC. When the database server is started with
> the -ca 0 parameter the connection speed turns out to be very slow but
> when I don't use this parameter the speed is like a rocket.
>
> Do you have any explanation / reason for this?
>
> I run SQL Anywhere 10.0.1.3750.
>
> Thanks & with best regards,
>
> Björn