Subject Re: [firebird-support] GStat
Author Alexandre Benson Smith
Robert martin wrote:

>Hi
>
>
>Sorry If im being dense here but, whats the SO cache? Would an 80MB
>cache be OK on a machine that only had 256MB (I think it would be
>alright personally)? Our app is used by a number of users and some may
>(probably not) have a limited amount of RAM. We want to handle the
>setting of this sort of thing for our users :)
>
>
Sorry....

This should be OS instead of SO (SO in Portuguese = OS in English :o) )

Do you understand what I say now you know that I meant the Operating
System Disk Cache ?


About 80MB FB cache on a 256MB server:
I think it's ok, if you have more memory better...

You should look when the FB server consumes all the 80MB how much are
free to the OS, look if it's paging to disk, if so, reduce the amount of
FB memory. If the server is going to disk you will not have a big
bennefit if FB keep a "big" cache since other app (or the OS) will need
to "swap".

FB will use RAM to sort result sets, if it gets low on memory it resorts
to disk sorting will be (of course) much slower.

>Rob Martin
>Software Engineer
>
>phone +64 03 377 0495
>fax +64 03 377 0496
>web www.chreos.com
>
>Wild Software Ltd
>
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005