--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:

> plenum3 wrote:
> Some time ago I switched from SS to CS on some of the servers I
> maintain. When the SS is under big load (monthly reports, etc.) it

just

> cuts all other users, and to them it seems like it just hangs. CS
> balances that load, so if someone runs monthly report, and other

users

> just want's to do a quick transaction, he doesn't have to wait few

hours

> to do it.

On multyprocessor machines with CS other users usually even don't
notice that somebody run heavy query. One more advantage - if owner of
one of the connections make something terrible and server crashes,
only his connection crashes, other don't notice this. SS dies entirely
with all users. And last - CS architecture is bridge into the future
in the sense of clustered servers.

Best regards,
Alexander.