14.11.2011 2:17, Vlad Khorsun wrote: > I thought about to change cache_writer in this direction - make it to do > "mini-flush" > instead of writting one page at time. But, note, we have no cache_writer > thread in CS\SC > and we can do a little (almost nothing) when page lock is downgraded (often > case in CS, i > think).
Yes, very common. In TPC-C, for example, AST level writes take about 30-50% of the overall writes. So I'd expect to see an improvement (if any) only in the non-concurrent scenarios with massive (larger than the page cache) modifications e.g. batch updates. Dmitry ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
