Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Ann W. Harrison
At 02:11 AM 12/4/2001 +0100, Ivan Prenosil wrote:
> From: Phil Shrimpton
> The two options that come to my mind are "Every Nth Commit" or "Every Nth
> Second"

Or when the server is idle.

That's tricky since we're asking the OS to do something
that we can't control ... if we wait too long, everything
may stop for a huge amount of disk access.

Or by FLUSH command.

From the commode utility? sorry. That's really putting a
burden on the system administrator.

Or after the system updates more crucial data (TIP?, page allocation? ...)

Again, this gets to be very similar to sync writes.

Regards,

Ann
www.ibphoenix.com
We have answers.