Don G. wrote:
-------------------------------------
There are times when IB starts doing some kind of processing, what I don't
know, and it uses at least 50 % of the processor or more and won't allow any
users to login to any database during this time. And the process usually
runs a
long time. The other day when it happened on my local Interbase I let it
run all night and came in the next day and it was still running. I end up
having to stop the service (which itself can take 15 or 20 minutes) and
restart it.
We have sweep set to zero on all of our databases, too, so I don't think it
is sweep. The last time it happened to me on local IB was when I ran a
simple select query using IB_Sql. The query ran fine but when I exited the
query IB started doing what I just described.
...
-------------------------------------

Do you do anything to sweep the database? Is GBAK run with garbage collection?
Could it be some massive garbage collection going on?

Regards,
Aage J.