Subject FireBird in a heavy load environment
Author uvdata
My company is about to implement a rather large installation which
has to deal with up to 400 concurrent users. Our environment is as
follows. We have bought 4 front end servers running an IBX-app on a
Windows Terminal Server 2003 (100 users / server), one server
working as domain controller and one back-end server. The back-end
server is a Win2003 server dedicated to running the FireBird
(superserver). My question is, and I know it is a tough
one, can I expect to run into performance problems when dealing with
400 concurrent users on 1-2 large databases (approximately 100 MB - 1
GB in size). The back end server is quite powerfull (2 x XEON 2.9 and
3 GB RAM, RAID-5). I know that I have to set CPU-affinity so that the
OS and the database runs on separate processors.

I am really interested in knowing whether anyone has experiens in
running FireBird in a similar environment. (By the way I have read
the user stories at IBPhoenix.com but I noticed that most of the
companies didn't have a large number of concurrent users).

Regards
Jan Jensen