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,