Subject Re: When do FB/IB 'flush' to disk?
Author karyakin@cmpmail.com
Hello,

"Phil Shrimpton" <phil@...> wrote in message
news:01113000385001.05467@fred...
>
> I think it is very important that at some point data is written to
the
disk
> files <g>

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).

> > > - I imported 200Mb of data in to a blank database
> > > - Left the server and client app idle for 4 hours
> > > - Pulled the power cord
> > >
> > > ...the database was blank after boot up
> >
>
> I am running a test at the momement, (with forced writes off), I
have
> inserted approx 1.5 GB into an empty database (and rising), and the
GDB
file
> is still only 3MB (I know about the explorer display issue). If I
pull
the
> cord, the database will be empty, but I am kepping the import going
to see
if
> Windows will eventually flush the data, or something blows.

Phil, could you provide some information:
-- is it NT4 and which service pack it has.
-- number of page buffers configured for IB,
-- database page size,
-- amount of RAM in the computer and
-- size of the server process working set while importing the data
(using the Performance Monitor it the Administrative Tools menu).

Thanks.

Regards,
Aleksey Karyakin

> Phil