Subject | RE: [firebird-support] Re: 2.1.3 CS - server hang |
---|---|
Author | Leyne, Sean |
Post date | 2011-04-28T19:52:43Z |
> > I don't think its a good idea to use CS on a Windows based computer.I disagree with William.
> >
> > 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?
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