Sorry, but can't be true. If true, al lot of people will have some GB
database size.
So there must be something that prevents:
- records to be deleted
- transactions to be committed
What isolation level do you use? Read committed, I hope.
And what's the code that performs the delete and what performs the
insert? Do you know that you have to use explicit transactions for
BOTH? Have you some transaction of Concurrency type open in the
meanwhile (e.i. in another cliend doing other tasks)?
Are you using Firebird, or an old and buggy Interbase Open Edition 6.01?
regards
Marco Menardi

--- In IBObjects@y..., "Arno Garrels" <arno.garrels@g...> wrote:
> I changed the source to Explicit Transaction handling.
> Now Commit is called whenever it might be usefull, but the problem
remains
> the same.
>
> No database no cry
>
> Arno Garrels
>
>
> ----- Original Message -----
> From: <lester@l...>
> To: <IBObjects@y...>
> Sent: Monday, December 02, 2002 1:50 PM
> Subject: Re: [IBO] Re: Database file size increases heavily
>
>
> > > I'm not a guru on this, so I could tell you lies, but as far as I
> > > remember reading posts in this newsgroup, I'm sure that a
> > > "myTransaction.Commit" will help a lot.
> >
> > Think you have hit it spot on!
> >
> > Only 5Mb in 10 hours - BDE/IB could manage that in 10 mins <g>
> >
> > --
> > Lester Caine
> > -----------------------------
> > L.S.Caine Electronic Services
> >
> >
> >
> >
>
___________________________________________________________________________
> > IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>
___________________________________________________________________________
> > http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >