Thanks for that, I had previously just read the first line about requiring
2.5 and eliminated it, now I see it has some capability with 2.1

On 14 May 2013 20:57, Thomas Steinmaurer <ts@...> wrote:

> **
>
>
> > I'm looking at increasing the cache size of my system to improve
> > performance but running into contradictory advice. (firebird 2.1.5 on
> > centos)
> >
> > http://www.firebirdfaq.org/faq333/ says "... You should not set the
> cache
> > size to consume large part of your RAM...."
> >
> > The new firebird book (p231) says " ...The first broad-brush optimization
> > you can try is to increase the default cache to a size that will occupy
> > approximately two-thirds of available free RAM. If there isn't enough RAM
> > installed, install more. ..."
> >
> > This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running
> > classic,
> >
> >
> > T
> > he book also (p231) says "use a monitoring tool to observe and record how
> > reads
> > and writes are satisfied from the cache" I've looked at several tools and
> > n
> > one seem to show this data, any suggestions what tool(s) to use here?
>
> FB TraceManager gives you the Cache Hit Ratio via monitoring tables and
> via the Trace API.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
>
>



--
Nick Upson, Telensa Ltd


[Non-text portions of this message have been removed]