Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Alex Peshkoff
On 04/07/11 15:09, Vlad Khorsun wrote: We can fix engine (make PIO_create to create files in FW=ON mode, or add new parameter to it) >> I think we must take isc_dpb_gbak_attach into an account. When it is >> set, let's keep old behavior. > gbak is OK. It set isc_dpb_force_write at

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Vlad Khorsun
>>> We can fix engine (make PIO_create to create files in FW=ON mode, or add >>> new parameter to it) > > I think we must take isc_dpb_gbak_attach into an account. When it is > set, let's keep old behavior. gbak is OK. It set isc_dpb_force_write at least since FB 1.5. > And to minimize per

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Vlad Khorsun
>> So, i think, this is the bug. > > Agreed. > >> We can fix engine (make PIO_create to create files in FW=ON mode, or add new >> parameter to it) but >> we can't fix old applications which creates database and expect fast work in >> this first attachment. > > As for me, a possibility to have

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Alex Peshkoff
On 04/07/11 14:39, Dmitry Yemanov wrote: > 07.04.2011 14:15, Vlad Khorsun wrote: > >> So, i think, this is the bug. > Agreed. > +1 >> We can fix engine (make PIO_create to create files in FW=ON mode, or add new >> parameter to it) I think we must take isc_dpb_gbak_attach into an account. When i

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Dmitry Yemanov
07.04.2011 14:15, Vlad Khorsun wrote: > So, i think, this is the bug. Agreed. > We can fix engine (make PIO_create to create files in FW=ON mode, or add new > parameter to it) but > we can't fix old applications which creates database and expect fast work in > this first attachment. As for me

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Vlad Khorsun
> On 04/07/11 11:00, Vlad Khorsun wrote: >> Right after CREATE DATABASE and until disconnect database works with >> actual FW=OFF, >> despite of settings on header page. We specially didn't changed this to make >> restore fast and >> simple (no need to disconnect and no chance to lose exclus

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Alex Peshkoff
On 04/07/11 11:00, Vlad Khorsun wrote: > Right after CREATE DATABASE and until disconnect database works with > actual FW=OFF, > despite of settings on header page. We specially didn't changed this to make > restore fast and > simple (no need to disconnect and no chance to lose exclusive at

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Geoff Worboys
Vlad Khorsun wrote: > Right after CREATE DATABASE and until disconnect database > works with actual FW=OFF, despite of settings on header page. > We specially didn't changed this to make restore fast and > simple (no need to disconnect and no chance to lose exclusive > attachment). I am quite

Re: [Firebird-devel] Performance after CREATE DATABASE

2011-04-07 Thread Vlad Khorsun
Right after CREATE DATABASE and until disconnect database works with actual FW=OFF, despite of settings on header page. We specially didn't changed this to make restore fast and simple (no need to disconnect and no chance to lose exclusive attachment). Regards, Vlad ---

[Firebird-devel] Performance after CREATE DATABASE

2011-04-06 Thread Geoff Worboys
Hi All, Wasn't sure whether to start here or on the support list. Came here because it partly relates to another thread. I was trying to create a script to reproduce the problem described by Thomas in the thread: [Firebird-devel] GEN_UUID() performance? At first I had trouble seeing the problem