| Subject | Re: FB-1.5.2 slow performance and high memory usage after insert and delete 30M |
|---|---|
| Author | mikcaau |
| Post date | 2006-01-06T08:43:53Z |
--- In firebird-support@yahoogroups.com, "intellekta"
<uwe.cramer@i...> wrote:
Mick
<uwe.cramer@i...> wrote:
>Commit your transactions
> 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
Mick