Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - 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.


2 posts in General Discussion Last posting was on 2009-03-27 14:18:31.0Z
ivh Posted on 2009-03-26 17:52:57.0Z
From: ivh
Newsgroups: ianywhere.public.general
Subject: cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
Date: 26 Mar 2009 09:52:57 -0800
X-Trace: forums-1-dub 1238089977 (26 Mar 2009 09:52:57 -0800)
X-Original-Trace: 26 Mar 2009 09:52:57 -0800,
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7437
Article PK: 5848

hi all.

when i have 2gb ram in my server , how percent cache max
required assigemnt to my service


"Nick Elson [Sybase iAnywhere]" < Posted on 2009-03-27 14:18:31.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@>
Newsgroups: ianywhere.public.general
References: <>
Subject: Re: cache
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
Message-ID: <49cce037$1@forums-1-dub>
Date: 27 Mar 2009 06:18:31 -0800
X-Trace: forums-1-dub 1238163511 (27 Mar 2009 06:18:31 -0800)
X-Original-Trace: 27 Mar 2009 06:18:31 -0800,
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7441
Article PK: 5856

There is no one perfect setting for this.
It really depends upon the specifics
of your database design, the data and
its distribution, the queries to be ran
and your usage.

We used to suggest starting with a
cache size of around 10-15% that
of the database size but that was only
a starting point. You will usually find
that is either not enough, or more than
sufficient. Just monitor the situation
and adjust accordingly.

The server will dynamically alter the
amount of cache it uses but that
is within the upper and lower limits
provided [see the -ch and -cl switches]

In parting, if this machine is going to be
dedicated to running just the database server,
then you can give it up to some level over
1.5GB of cache. But if it is going to need
to host other applications as well, it may need
to be smaller than that. This is just the upper
reaches of what is possible (32bit software),
not what is recommended or what you'll find
you may require.

<ivh> wrote in message
> hi all.
> when i have 2gb ram in my server , how percent cache max
> required assigemnt to my service
> thanks