|Subject||RE: [firebird-support] Forced write, page size and buffer size|
> Given this scenario my questions are the following:Different versions of Linux file systems provide better protection than others.
> 1) Does it makes sense to activate forced writes on Linux ?
Personally, I believe that forced write = ON is necessary for all OS -- but I suspect that I am in the minority (some will swear they have never had a problem/db corruption, but I am too chicken to take the risk -- I like sleeping at night).
> 2) Is increasing the page size the right approach to improve performance ?There is no universally true answer, it depends.
> Which are the drawbacks of setting page size to 16K ?
> 3) The same question stands for cache pages: is it useful ( or hasAs long as you have the RAM there is no problem.
> disadvantages ) to have so many cache pages as there are on disk pages (
> provided there is enough RAM size ) ?