> > I need 'forced writes = ON' without the performance penaty <g>, or failing
> > that, so way of signaling FB to flush its file(s) either manually, or
> > automatically (like the sweep thread)
>
> How would flushing differ from forced writes? I'm not sure I get the idea.

Forced writes flushes every write. I knew ( but up to now
had not seen proof ) that with Forced write off, there was a
problem. I think that what is being asked for - and is
needed - is an option where rather than writing EVERY
'packet', they get writen when there are a number, or when
disk activity is quiet. THAT is what I was lead to believe
the Windows caching did. It doesn't, so since Microsoft
won't fix it how do we?

This is not just a database problem, I had the same
difficulty with log files - the system crashed but there was
nothing in the log <g>. Now I open - write - close, not very
efficient but it's the only way?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services