On 15 Sep 2005 at 10:23, Raith, Daniel wrote:

>We have our application hosted via ASP. We are moving data around and
>in the end our ASP will have one data server that will have ~400 users
>connecting to ~100 databases (average 4 connections per database). The
>server is an HP Proliant ML370 G3. Dual XEON 2.8Ghz Processors, 4GB
>RAM, approximately 200GB of disk storage, running Firebird 1.5.2.4731,
>super server install.
>
>Does this sound like an acceptable setup?
>Can firebird handle that number of connections?
>Is there a guide to this kind of stuff somewhere?

There is one answer for all questions: try and see results.

I'd like to point out that you don't have to keep all databases on
the same DB server. FB is free. Set up 10 servers, put 10 databases
to each and you'll finish with ~40 connections to a server.

--
SY, Dimitry Sibiryakov.