--- In firebird-support@yahoogroups.com, Sándor Tamás <san_ta@v...> wrote:

> In fact, we use a self-made application to move huge amount of

datas. On single processor system, and SS it takes approx. 30 minutes.
If we use SS on a multi processor system, it takes approx 3-3,5 hours. :(

Go to the firebird.conf and locate and set the CPU Affinity setting.
This will lock the process to a single CPU. Save, and restart the
firebird service (if you don't do that, it wont work). It should then
be comparable in performance to a single CPU system. In fact it will
probably be marginally faster, as other processes can use the other
CPU rather than fight for the one you are using.

You won't get any real advantage from CS if you are not using multiple
connections to do the work.

Adam

> ----- Original Message -----
> From: Adam
> To: firebird-support@yahoogroups.com
> Sent: Tuesday, September 20, 2005 10:59 AM
> Subject: [firebird-support] Re: Difference between Classic &

SuperServer F1.5.2

>
>
> --- In firebird-support@yahoogroups.com, "rekkod" <anton@d...> wrote:
> > Hi All
> > what is the difference between Classic & SupperServer.
>
> There is a whole FAQ on the topic on the Firebird website, here is the
> direct link to the whitepaper.
>
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_ss_vs_classic
>
> In a nutshell, Classic (CS from here on) spawns a new process for
> every connection, Superserver (SS from here on) spawns a new thread
> within the single server process for every connection.
>
> CS will therefore consume more resources per connection than SS and
> can not share a common cache. SS can also have a dedicated garbage
> collection thread rather than relying on cooperative garbage

collection.

>
> There are a couple of problems with SS that mean that in some cases CS
> is a better choice. Firstly, in multi processor machines, SS is
> (currently) unable to send different threads to different CPUs, so in
> multiple CPU systems (or even in hyperthreaded systems) at best the
> server is executed only on a single CPU (which is a waste). At worst,
> the OS goes silly and see saws the process from one CPU (or virtual
> CPU) to the other, making it even slower than if there was only a
> single CPU.
>
> Adam
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]