Hi Aaron! Why did you hijack "FB 1.5.2 terminates abnormally (-1)"
(second time in less than 24 hours I answer a hijacked thread in this
forum)? Never hit 'Reply' when your question is of no relevance to the
thread.

Something has to be different with this machine compared to the other
ones.

Are you using a different versions of Firebird?
Does this machine have two CPUs whereas the others have one CPU?
Different data making the optimiser choose a different plan for the
same query?
Different type/number of users?
Less available harddisk space for temporary files?
Inactive indexes?

I cannot help you unless you tell us how this machine differs (in
fact, I doubt I could even if you told us the cause), but others will
have more ideas.

HTH,
Set

--- In firebird-support@yahoogroups.com, "Aaron Abend" wrote:
> Hi all,
>
> I have installed fbserver (superserver) and when it starts serving
> database requests from my application, fbserver proceeds to eat 99%
> of the CPU and the user's system essentially hangs as the
> application itself is starved. I have allocated more memory to the
> server in firebird.conf but it does not seem to go past 20MB. I'd
> be happy to let it eat twice that much RAM if it would leave the
> CPU alone.
>
> Is there any way to configure/control Firebird's appetite for CPU?
>
> I have not seen this problem on machines (with faster CPUs), so
> there is a possibility there is a local problem that is causing a
> problem on this specific machine. But my guess is that it is
> something I will have to know as I roll my application out to other
> users. All ideas welcome.