Subject Re: problem using backup (Classic vs SuperServer)
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, Doru Constantin <doru@o...>
wrote:
> Fabian Chocron wrote:
>
> > I have tested it, and Classic Server is far much faster than
> > SuperServer (On
> > Windows 2K Server, and I guess on XP & NT too, but i doubt on
95/98/Me).
> >
> > Also, you can use more than 1 CPU on Classic, but you will need
much more
> > RAM. Basicly, proper Microsofts OS (NT & 2K) will perform much
better with
> > multiple "instances" of a program rather than a simple Application
with
> > "Internal Threading". On the other hand, SuperServer will save
lots of
> > money
> > in terms of RAM and CPU.
>
> about how much RAM are we talking about?

At least database_cashe_buffers*database_page_size for Super should
be multiplied on amount_of_users for Classic. Note each running server
process consume resources itself. Last depends on complexity and
amount of Stored Procedure usage and transactions lifetime.
BTW, my observations on Super (very limited, I'm Classic fan) in
general shows Super is more quick serving single connection but
Classic have much better load ability. When Super looks as entirely
'frozen' by some heavy query and practically stops serving other
connections, Classic slowed, but moves. And this is particularly
noticeable on multiprocessor machines. I have'nt HT machines so can't
surely speak about this.

Best regards,
Alexander.