|Subject||Re: FB-1.5.2 slow performance and high memory usage after insert and delete 30M|
--- In firstname.lastname@example.org, "intellekta"
>Commit your transactions
> 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