On Mon, 2 Feb 2004 21:14:22 +0000 (UTC), Sandeep Chandra wrote:

> I'm using FB1.0. If my freezes then all other apps running of the server,
> using FB freeze. After I close the app that caused this freezing FB
> server comes back and all other apps come back and can be used. Is it FB
> or Widowz doing this? Is anyone else getting this?

My first guess would be a bad quuery - joining large tables without
using/having indexes. I experienced this last week after having dropped
and recreated a table (forgetting about indexes). This caused Fb to
consume 100% CPU until the offending client was terminated.
Establishing the proper index solved the problem.


--
Aage J.