Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Daniel Rail
At 03/12/2001 09:11 PM, you 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.
>Or by FLUSH command.
>Or after the system updates more crucial data (TIP?, page allocation? ...)

I know that I might be repeating what is said above, but with some of my
own 2 cents about them.

I would like that certain options would be available to the db-admin and he
decides how it applied, but not be able to leave it as it is now. I'd like
to see at least when the system is idle and/or periodic time frame. With
lots of connections, you never know when the server will actually be
idle. I could say after every system update for the crucial data. Also,
maybe add an SQL statement to be able to flush the data to disk(I noticed
that FoxPro has it), this would make possible for a programmer to tell the
server to flush the data to disk, when data importing is completed.

This is just my 2 cents.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (