> On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: >> On 17/11/2011 07:52, Dmitry Yemanov wrote: >>> The only way to guarantee ordered writes is to flush individual pages >>> and this is what FW=ON does. >> Or to flush group of independent pages at once, like I proposed. I think >> this can be a great improvement for FW=ON. > > The suggestion appears very interesting, even with average size of group > == 2 engine shoudl run almost twice faster.
You are too optimistic :) If independent pages are not adjacent, there will be much less performance win. And, note, most heavy case (flush on commit) is already optimized. Regards, Vlad ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel