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


> I'm trying to reproduce the situation and, unfortunately, without a
> success yet. On a computer with 256M RAM (W2K server) the data is
> phisically written within few seconds (tested by hard power off).

Are you leaving the connection open? I can reproduce this at will quite

> Phil, could you provide some information:
> -- is it NT4 and which service pack it has.

NT4 SP6a and W2K SP2

> -- number of page buffers configured for IB,


> -- database page size,


> -- amount of RAM in the computer and

256 - 512 (I have triend on a number of machines)

> -- size of the server process working set while importing the data


Which I believe is 10,000 x 8K = 80Mb for the Cache, and 4,244 for the actual


Linux 2.4.4-4GB
5:40pm up 6:34, 1 user, load average: 0.51, 0.27, 0.21