Subject RE: [firebird-support] Re: Firebird Usage Load Problem
Author Rick Debay
Around the year 2000 when I was at another company, a Sun reseller set
up a Solaris server with Oracle for us.
At that time they tuned the system to be CPU bound.

This is a red herring, some resource is always going to restrain the
system, whether it's memory, disk, or CPU.
No restraint is better than any other.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Maurice Ling
Sent: Thursday, July 14, 2005 7:09 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Firebird Usage Load Problem

--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@b...>
wrote:
> Ok man... I dunno if you are aware of it or not, but what you see in
> "top" is pretty irrelevant. On my system, I could have.... say...
> SETI@HOME running. The thing takes 100% cpu... EXCEPT when something
> else is running... then it takes what is left. It is executed on a
> different priority level, and you can certainly jam firebird into
> sucha mechanism, probably with the "nice" command.
>
> Firebird, like EVERY OTHER APPLICATION uses as much CPU as it needs,
> and the Operating System divides up the processing time. The reason
> something like a python script would only take 1.5% CPU vs. 100% is a
> lot of waiting inbetween stuffs.
>
> Jason
>

On its own, I can understand that Fb may want to use as much CPU as it
has. However, in the light of relatively modest usage by mysql or
postgres (both averaging CPU load at 1.5-5% everyday), the argument does
not hold. Furthermore, shouldn't FB be more I/O intensive than CPU
intensive?

cheers
maurice




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links