Subject | Re: [firebird-support] Re: How to maximize cpu usage for Firebird? |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-07-18T06:57:08Z |
Hello, trskopo!
Thursday, July 18, 2013, 10:39:04 AM, you wrote:
t> I have only 1 database in this machine. You said SuperClassic use 1 core per database connection.
t> For 1 connection I got cpu's utilization about 16%, so, if there
t> are 8 connection to the same database, running the same task, cpu's utilization will
t> jump to 100%?
Classic and SuperClassic uses cores for multiple users,
SuperServer - use only one core.
But, if you use Classic or Superclassic, it does not guarantee
that you will have 100% CPU load.
RDBMS is not a calculator to load only CPU. RDBMS mostly cracks data.
And data is on disk or in memory.
So, if you have bad disk or memory I/O, CPU will mostly lower than
100%, because CPU load depends on what Firbird engine is doing to
execute your query.
--
Dmitry Kuzmenko, www.ib-aid.com
Thursday, July 18, 2013, 10:39:04 AM, you wrote:
t> I have only 1 database in this machine. You said SuperClassic use 1 core per database connection.
t> For 1 connection I got cpu's utilization about 16%, so, if there
t> are 8 connection to the same database, running the same task, cpu's utilization will
t> jump to 100%?
Classic and SuperClassic uses cores for multiple users,
SuperServer - use only one core.
But, if you use Classic or Superclassic, it does not guarantee
that you will have 100% CPU load.
RDBMS is not a calculator to load only CPU. RDBMS mostly cracks data.
And data is on disk or in memory.
So, if you have bad disk or memory I/O, CPU will mostly lower than
100%, because CPU load depends on what Firbird engine is doing to
execute your query.
--
Dmitry Kuzmenko, www.ib-aid.com