Subject Re: [firebird-support] Running out of database!
Author Hannes Streicher
Guten Tag hay77772000,

> We have a series of severs that are each running Tomcat, and load
> balanced through Apache. They all share the same firebird database on
> a dedicated machine on the backend - v1.5. We initially started with
> SuperServer, but had stability and other problems with that, so we
> switched to Classic. Each server uses a db connection pool with
> approx 30 connections.

> When we scale up, we seem to hit a wall at around 7 servers, where the
> database machine cannot keep up.

> Can anyone suggest ways that we can get around this issue? Does
> anyone have experience with some of the other "commercial" dbs -
> Oracle/Sql Server etc.? Would switching to one of these likely help us?

Sorry, do not expect any usefull answer to your question , since you
do not give any details

Which Server Hardware , CPU ,RAM ,Disks
how are disks attached pata sata scsi how many rpms
Which Server OS

Have you checked / optimized the Queries Already
Are you mainly inserting data into the Database , or ist it mainly
retrieving data

how timecritical are your queries as to returned results ,
could you use replication of the database
in order to run it simultaneously on multiple servers

Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...