thisllub wrote:

> Thank you very much for your response.
> I will purchase a single core cpu machine and hope it lasts me until
> Firebird 3. 8 months of stability has stopped my client from talking
> Microsoft - at least for now. A great relief for me.
>
> I have tested SuperServer in a few configurations and come to the
> conclusion that it is not really suitable for more than a few users.
> Whilst it provides good performance for one or 2 users it quickly
> becomes pretty much unusable as the number of users increases. I
> suspect that 8 users would be the practical limit.
> In fact I find the performance difference so profound I am unsure as
> to why the SuperServer model even exists.
>

I doubt it...

I have a costumer running FB 2.0 SS on a Windows2003 box, server is P4
1Ghz 1GB RAM. This setup is serving around 60 users.

I have others running SS on Linux machines serving around 15-20 users

Everything depends on how you write your app, once CS has separated
process for each connection, no one would being "stopped" to work if one
connection requests a very slow statement. The OS scheduler will handle it

Some questions... how do you handle your transactions ? could you show
us the database statistics when you find your database slow ?

Could you show us a typical statement that you think is slow and the
execution plan ?

> Congratulations on FlameRobin.
> It is an excellent piece of software that I use daily.
>

Seconded !

I suggest you to have a look at another piece of Milan's work, take a
look at NjAM (http://njam.sourceforge.net) game... (sorry for the off-topic)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br