Subject | Re: Help, tunning database |
---|---|
Author | Paul Beach |
Post date | 2013-07-31T21:21:51Z |
> Today, I faced same problem again, which is Firebird server became not<<I suspect that the problem is the noted problem with Windows File Cache on 64bit Windows systems -- the OS is loading too much
> responsive.
>
> Here are the latest settings :
> - win 7 64 bit
> - Firebirds 2.5.1 super server
> - page size 8192
> - page buffer 8192
> - no long transactions
> - temp cache limit set to 128MB
> - there are a few numbers errors in insert operations but all already rollback.
into file cache which is causing a huge/excessive number of cache page writes, which results in the system grinding to a halt. So,
the problem is not with FB but with Windows.
Please google/yahoo this subject (it has also been mentioned in this list several times).>>
http://dyemanov.blogspot.fr/2012/03/firebird-vs-windows-file-system-caching.html
http://tracker.firebirdsql.org/browse/CORE-3791
Fixed Firebird 2.5.2
Paul