Subject Re: [firebird-support] Firebird classic vs supperclassic
Author Thomas Steinmaurer
> Hello, we have to select between the two models for a new client. Is a critical system that will run 24x7x365 with an average of 100-200 concurrent users and 5 Gb database growth a year, starting with 10 Gb database.
>
> The deployment will Windows 2008 R2 64, 32 Gb RAM and the most important is the reliability of the system.
>
> Superclassic is out a year, but a lot of people prefer classic over SC. I would like to know experiences of people using them, and the reliability of both from your POV.

The thing with SC is, when something bad happens in a connection, which
crashes the server, e.g. due to a bug in the engine or a faulty UDF, all
connections are affected. This is probably the reason why people still
prefer Classic over SC. SC might be easier to manage, because you only
see one process in the task manager and according to some benchmarks, SC
seems to be a bit faster than Classic.

I guess you know this architecture comparison sheet already?
http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf

--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php


> Regards,
> Jesus
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>