Subject Confusion between CS and SS suitablilty
Author Nigel Weeks
It appears a decision matrix needs to be created to determine where to use
Classic Server, or SuperServer.

If we throw around the points, maybe it could be created on the website, so
people don't think that SS is the latest and greatest all the time?

Factor Classic Server
Super Server
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Guaranteed simple, short transactions, OLTP
(No complex analysis, limited reporting) Good
Excellent

Moderate transaction complexity, OLAP
(Complex analysis, More reporting) Excellent
Good(Can block other operations on complex queries)

Single processor machine Excellent
Excellent

Multi-processor(SMP and HT) Excellent
Poor(Requires Affinity - back to 1 CPU performance)



Perhaps something like this is more suited for firebird-general.sorry!

Nige.



Nigel Weeks
Tech Support & Systems Developer
nweeks@...
www.examiner.com.au
71 - 75 Paterson Street
Launceston
Tasmania 7250
Australia
Phone: 03 6336 7234



[Non-text portions of this message have been removed]