--- In ib-support@y..., "Pilahaka" <list.box@r...> wrote:

> I've read that the classic server
> does not perform as well as the superserver and that using the

classic

> server in a multi-processor environment only yields a 20%

performance gain.

> Not quite linear scalability. Does the 20% performance gain on a

dual

> processor machine match your experience?

Hi. Super really have better performance when many clients perform
many simply queries on the same data and in single-user mode. On my
database I created additional indexes on system tables and performance
is no worthe than it was when I tested Super (without this indexes :)
). I reported it several times here but this reports were ignored,
later this indexes were implemented in Yaffil. We use Classic not for
performance but for load ability. Super can be hanged by one
inaccurate query which will consume all resources. Classic will slow
down another connections but will not hang them, especially on
multi-processor machine, we can combine regular data registration work
and heavy reports building and users don't feel significant
performance degradation. Second advantage of Classic is when one
connection make query which lead to server crash, crashes this
connection only while Super dies entirely.

Best regards, Alexander V.Nevsky.