--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

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

The size of the database stays the same from its creation.
The database can get very big and i don't want the application to
keep all the data in the memory.
Also the durations for inserts is getting slower with time.