On 12/16/11 13:39, Adriano dos Santos Fernandes wrote: > On 16/12/2011 05:24, Vlad Khorsun wrote: >>>>> So now we're spending time while the database is not even completely >>>>> created. >>>> While we can restore previous behavior (put FW ON flag at header page >>>> when database is created but create db file with this flag switched off) i >>>> prefer >>>> to ask - are we really want to maintain this hack ? Wouldn't it be better >>>> to add >>>> support of the all existing DBP tags to the CREATE DATABASE statement >>>> and adjust TCS and gbak correspondingly ? >>>> >>> Maybe, but I don't think the wish for a faster CREATE DATABASE with >>> FW=ON is a hack. If this is true, seems we have a design problem. >> Faster CREATE DATABASE ? It is fast enough :) Faster inserts ? It >> depends. >> And it depends on FW setting also. And when we have some setting ON on disk >> and OFF in memory at the same time - yes, i consider it as a hack. >> >> > No, *it's not* fast enough in the case of ext4. > > Around 3s to create a blank database is too much. And as I said, there > is no need to care about safety database creation while it is still not > completely created. > > I'm not saying to leave the FW=OFF until a next command like 2.5, but to > set it to ON *after* the create is complete, not in the middle of it > like now.
I see no problems with suggested solution. Just take into on account that in linux we need reopen file to change SYNC mode, though I do not see at first glance what can be bad with it. ------------------------------------------------------------------------------ Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
