>> How do you know that you are CPU and not I/O bound?
>>
>> SuperClassic is capable to utilize SMP environments, but simplified one
>> core per database connection. If you increase the number of database
>> connections with CPU bound stuff, you should see an increase of CPU
>> utilization.
>>
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird
>> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>>
>
> Thanks for your reply.
>
> I run a few queries, all almost stuck at 16% cpu's utilization, so I guess, file I/O is ok.
>
> I have only 1 database in this machine. You said SuperClassic use 1 core per database connection.
>
> For 1 connection I got cpu's utilization about 16%, so, if there are 8 connection to the same database, running the same task, cpu's utilization will jump to 100%?

I doubt 100%, but more than 16%, if the other connections/workloads
forces the Firebird server process to be CPU bound.

Check out my following demo video here, discussing SMP utilization with
different Firebird architectures:
http://www.iblogmanager.com/download/demos/firebird/fb25_architectures_smp.html


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.