Subject Re: FB-1.5.2 slow performance and high memory usage after insert and delete 30M
Author intellekta
--- In firebird-support@yahoogroups.com, "mikcaau" <macomp@s...> wrote:
>
> --- In firebird-support@yahoogroups.com, "intellekta"
> <uwe.cramer@i...> wrote:
> >
> > Hello,
> > we have inserted and deleted ~ 30.000.000 records in a
table.(buggy sp).
> > after that the client performance slows down to 1/10 and the memory
> > usage in fbserver goes from ~200KB to ~800KB.
> > sweep does not change this situation.
> > the database filesize goes from ~14GB to ~22GB
> > the backup filessize after sweep is a little bit bigger as it was in
>
>
> Commit your transactions
> Mick
>
thank you for the info but how ?
Uwe