At 09:58 AM 6/1/2001 -0300, Luiz Alves wrote:

>If I issue a massive deletion of records from a table or several tables,
>often IBServer stays using CPU in 100%, for many time(hours) after complete
>the sql command. During this time, it no more accept whichever connections
>from clients and stops to server all others client requests.
>
>After some time, all come back to normal.
>
>Is this a normal behaviour?

I guess I must admit that the behavior is normal - not desired or
designed, but normal. Deactivate all but the primary key indexes
before you do a massive delete and the problem will go away.


Regards,

Ann
www.ibphoenix.com
We have answers.