Subject Re: [firebird-support] Performance issue
Author Mark Rotteveel
On Wed, 6 Feb 2013 14:26:24 +0100, André Knappstein
<Knappstein@...> wrote:
>> Checkout the releasenotes of 2.5 on the filesystem cache:
>>
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-fbconf-fscache
>
> Did so before, and did now again.
> Did not clearly understand if it is important for Win200_8_x64.
>
> Is that important for "(Microsoft Server 2003 host with SP1) and
> higher" (including Server2008, Server2012) or "(Microsoft Server 2003
> host with SP1 and higher)" (including W2K3 SP1 - SPn)?

As far as I know this includes Server 2008 etc, as I believe the
filesystem cache in those windows versions is unchanged.

> If a machine has enough RAM (e.g. users * databases * pagesize *
> pagebuffers * 2^x), is it eligible to say "FSCThreshold can always be
> set to 0"?

That would disable filesystem cache entirely. I can't say if that is a
good idea or not.

Mark