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. Adriano ------------------------------------------------------------------------------ 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