> --- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
> <ts@i...> wrote:
> > > Yes, I commit the inserts regularly.
> > > How can I set "forced writes = ON" on database level ?
> >
> > Use gfix in combination with the -w switch, whereas
> >
> > sync = FORCED WRITES ON
> > async = FORCED WRITES OFF
> >
> > For example:
> >
> > gfix –w sync –user SYSDBA –password masterkey <your_database_path>
> >
> >
> > To check whether forced writes is on or off, check the database
> > header page by using gstat -h.
> >
> > For example:
> >
> > gstat –h –user SYSDBA –password masterkey <your_database_path>
> >
> >
> > If there is a line
> >
> > Attributes force write
> >
> >
> > in the output stream, then forced writes is ON, otherwise it's OFF.
> >
> >
> >
> > HTH,
> > Thomas
>
> If I check the database with gstat the line Attributes force write is
> there, but still the size of the database file doesn't increase
> during the Java application runs.
>
> Any other ideas ??

It still can be the case that you've previously inserted and deleted
records, so the already allocated database pages gets reused for the
newly inserted records.

Btw, is there a specific reason why you would like to see the database
file gets bigger?


Thomas