Subject Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)
Author Ann Harrison
> On Oct 29, 2014, at 9:36 PM, Geoff Worboys geoff@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
>
> Doesn't that depend on how they implemented the separate threads?
> SS does/can use different threads for separate connections to the
> same database, can't it?

Yes.

> So if the threads operate over separate
> connections then wouldn't SS be able to use multiple CPUs?

The threading was designed for a single CPU machine so they don't make any effort to share data structures. Multi-threaded, yes. But only one thread can run at any one time. That's what's great about V3 - threads running in parallel with a shared database page cache.

Cheers,

An
>