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

> > > > 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
> transaction.
>
>
> Thomas

Ok. I found my mistake with the file size - IExplorer didn't show the
right file size.
But is it normal that the time of inserts grows up constantly ?