Subject RE: [firebird-support] Re: Firebird on Windows
Author Thomas Steinmaurer
> > > 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.

Perhaps this is a dumb question, but are you looking at the
right database?

If you have FORCED WRITES ON, then data changes should be
written to the disk.

Regarding the speed issue. Make sure that you are using
parametrized queries and a "hard" commit and not a "soft"
commit (= commit retaining) when committing data changes.

How does the database header page looks like if things
are getting slower? You should especially have a look
at the counters of the oldest/oldest active/next