>
> How large are these tables? For how long is the CPU at 100% ?
> 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.

What I am saying is I want to know if we move from IB6.0.1.6 to
FB1.5 will this solve our major problem with IB6.0.1.6 that is
that the sweeping takes over the machine CPU?

The CPU can be at 100% for over 15 minutes.
We only use primary indexes as a rule. These should never be inactive.
because we can not allow duplicate records.


Regards,

Robert.