Subject Re: [firebird-support] Re: Maximum speed for insert with embedded server
Author Jody Belka
On Wed, Aug 11, 2004 at 05:53:30PM -0300, Daniel Rail wrote:
> At August 11, 2004, 17:18, Milan Babuskov wrote:
> > AFAIK, it depends on the operating system... whenever it decides to
> > flush HDD buffers.
>
> Not with the new config parameters, for FB 1.5 on Windows:
> MaxUnflushedWrites and MaxUnflushedWriteTime. These parameters are
> used to flush the buffers to be written on disk either after a number
> of buffer/page writes or an amount of time(since the last buffer/page
> write), whichever comes first. And, the Win API that is used will only
> return control to FB after the hard-drive itself (not the OS) says
> that the data was written to disk.

And of course, you can also turn off write-caching completely in windows
(also on a per-drive basis with 2k,2k3 and xp). Probably worth doing for
absolute safety.


--
Jody Belka
knew (at) pimb (dot) org