Subject Re: [firebird-support] Re: 2.1.3 CS - server hang
Author Wei Yu
Window OS is not capable of Multiple threading, you could use cs on Windows.
but whether you can get a better performace using cs than ss, thats
questionable. sometimes you can even get worse performance by using cs.

William


On Thu, Apr 28, 2011 at 3:52 PM, Leyne, Sean <Sean@...>wrote:

>
>
> > > I don't think its a good idea to use CS on a Windows based computer.
> > >
> > > William
> > >
> > Then If ss is not recommended for a lot of concurrent users, in Windows
> > firebird with more than 50 users must not be installed?
> >
> > Is that limit for Windows server family documented?
>
> I disagree with William.
>
> Classic server is fine with Windows!
>
> We have over 60 production Firebird servers running Windows, some servers
> with 100s of database connections.
>
> What you need to remember is:
>
> - Each database connection starts a new server process, so more RAM memory
> is needed/used
>
> - Each database page cache setting should be kept low, improve performance
> by reduce the amount of synchronization which occurs between the Firebird
> processes
>
> - 64 bit versions of Windows (very true with 2008) have a poor algorithm
> for managing OS page cache, which can result in an excessive amount of cache
> paging, which severely impacts performance. There are some utilities
> available (SET_CACHE.EXE) which can set the cache size to definable level
> (we usually set it to 70% of available RAM).
>
> Sean
>
>
>


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