Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Claudio Valderrama C.
"Phil Shrimpton" <phil@...> wrote in message
news:01112716155404.30819@fred...
> On Tuesday 27 November 2001 14:35, you wrote:
>
>
> I thought that Windows would eventually flush the pending writes to the
file
> in idle time, but in a test...
>
> - I imported 200Mb of data in to a blank database
> - Left the server and client app idle for 4 hours
> - Pulled the power cord

Which Windoze flavor, before anything else, Phil?
Then it comes the issue of the filesystem used.
Did you commit in that period or not at all? Failure usually means rollback,
as you know. Maybe you need server autocommit mode for that simple "raw
push" operation.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing