| Subject | Re: [firebird-support] Sweeping that doesn't take 100% CPU |
|---|---|
| Author | Aage Johansen |
| Post date | 2004-05-01T11:12:12Z |
On Fri, 30 Apr 2004 02:28:47 +0000 (UTC), robertgilland wrote:
If you have a lot of indexes on the tables, try to set them inactive before
sweeping (or use drop-sweep-create). In particular if your tables are
large with a lot of duplicates in the indexes.
--
Aage J.
> Sweep is Garbage Collection.How large are these tables? For how long is the CPU at 100% ?
> We use transaction tables that regularly get emptied.
> Helen Borrie does the same thing.
> Thus we need to sweep but we don't want it to take over
> the full CPU.
If you have a lot of indexes on the tables, try to set them inactive before
sweeping (or use drop-sweep-create). In particular if your tables are
large with a lot of duplicates in the indexes.
--
Aage J.