Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Phil Shrimpton
On Wednesday 28 November 2001 11:11, you wrote:


> Which Windoze flavor, before anything else, Phil?

NT and W2K

> Then it comes the issue of the filesystem used.


> Did you commit in that period or not at all?

Yes, every few thousand records. After the 'import' has been completed, I
can log into the database with ISQL or what ever and see the data, it is just
not being flushed to the GDB file(s)

> Maybe you need server autocommit mode for that
> simple "raw push" operation.

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)


Linux 2.4.4-4GB
11:54am up 35 days, 5:04, 2 users, load average: 0.84, 0.54, 0.24