Hi Maurice!

Firebird just loves to eat CPU if it can use it! Unfortunately, I
doubt there exists a way to restrict the Firebird server in this area.

But the client can be restricted as to which tasks it asks the server
to perform. Can you do something to your script to make it less
resource hungry? Firebird doesn't use memory unless it is used for
something, and a SELECT 5 from rdb$database or a query against the PK
doesn't take long enough for any administrator to become angry.
Whereas a SELECT COUNT without any WHERE clause on big tables -
particularly with joins on non-indexed fields - may require 100% CPU
and take days to execute.

Hence, I doubt we can help you to stop Firebird from using more than
10% of the servers' CPU, but we may be able to help you making your
script less resource hungry. Identify the time consuming parts, and
show us the problems you are unable to solve yourself.

Set

--- In firebird-support@yahoogroups.com, "Maurice Ling" wrote:
> I do like Firebird. I've even published a conference paper on it.
> But then, numbers for numbers, I will need to bring FB's CPU usage
> to less than 10%.
>
> Any insights?
>
> Cheers
> Maurice