Hi,

|I am using Firebird 2.0.3 on Intel DualCore processor and when I start
|some little complicated query statement and take a look on processor
|usage it is only one core used by Firebird and another one is 10% used.

If you're running only one connection you can't ger any better than that.
But if you're going to have many connections (users) then go with FB Classic
and you'll be able to get advantage on your multi-core CPU. FB SuperServer
can't do SMP.


Regards,
Anderson Farias