Due to my Firebird 2.5 architectures comparison sheet available HERE, I got a few requests on what's the difference in respect to SMP utilization between SuperServer and SuperClassic. I thought, creating a short demonstration video might be a good idea. It's available now:
Firebird 2.5 architectures SMP comparison demonstration video
Edit: I forgot to mention one important fact in respect to SuperServer in the video. Per default, SuperServer is bound to one CPU/Core. If you want to take advantage of a SMP environment with SuperServer with several databases, then you need to change the configuration parameter CpuAffinityMask in firebird.conf. The configuration value is a bit mask of the used CPUs/cores. So, in our example with 4 cores, the configuration entry is CpuAffinityMask = 15.
Enjoy!
Firebird 2.5 architectures SMP comparison demonstration video
Edit: I forgot to mention one important fact in respect to SuperServer in the video. Per default, SuperServer is bound to one CPU/Core. If you want to take advantage of a SMP environment with SuperServer with several databases, then you need to change the configuration parameter CpuAffinityMask in firebird.conf. The configuration value is a bit mask of the used CPUs/cores. So, in our example with 4 cores, the configuration entry is CpuAffinityMask = 15.
Enjoy!