Subject Re: [firebird-support] Performance issue
Author Mark Rotteveel
On Wed, 6 Feb 2013 12:52:58 +0100, André Knappstein
<Knappstein@...> wrote:
>> The basic issues is that, by default wants to cache all disk pages
>> and with a 64 bit OS it think it has a huge amount of RAM. So once
>> all physical RAM has been consumed Windows starts to read/write to
>> the disk page file, which causes an excessive amount of disk IO and
thus
>> slows the system.
>
> Sorry for sort-of sidejumping this.
>
> Am I still correct in thinking that all these fixes are applied to
> 2.5.2 and that I can quite safely install a 2.5.2 CS on an otherwise
> "naked" Win2008R2x64 without expecting trouble?
>
> I have a consulting session next week where I want to convince the
> audience to use FB instead of MSSQL and would not enjoy to get
> tar-and-feathered afterwards :-)

Checkout the releasenotes of 2.5 on the filesystem cache:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-fbconf-fscache

Mark