Hi,
 
i have read on http://firebirdsql.org/
article "23 More Ways To Speed Up Firebird".
 
Can you explain me point "12. Don't forget to enable file cache with big 
Firebird cache page".
 
I can imagine difference only in 2 situations.
 
1. When all attachments are disconnected and connected again.
Then yes, Windows cache can be more than benefit here - but we can turn on 
linger to achive near the same.
 
2. Database is bigger than Firebird cache.
Than using also system cache can increase performance as there is a chance that 
Windows will cache some portion of database not cached by FB itself.
And Windows can decide then, if it neeed cache other files or some portion of 
DB.
 
Is there any benefit of enabling system cache if Firebird cache is set to 
bigger value than database itself?
I see oposite performance in such situation.
But difference is marginally from 0 to 5% difference - than i do not know if 
there is any difference or i see some other process involved.
 
Are there other situations when enabling system cache will benefit also?
 
regards,
Karol Bieniaszewski
  • [firebird-supp... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    • Re: [fire... Alexey Kovyazin a...@ib-aid.com [firebird-support]

Reply via email to