> I am new with Firebird and Interbase development. I just joined to a
> small training company developing management simulators.
> We are using Firebird for the first time in a system for four
> clients and one database server. The client software are based in
> two parts: one dataentry (that populate the database) and
> one 'executor' (that run the simulator tasks). At the first time we
> run the sistem with only one client and the dataserver. It was ok.
> We also tested the 'executor' alone and it worked fine. When
> starting the client and the 'executor' all together the system
> stopped (we could get 11 minutes to run de 'executor' alone and near
> 60 together with the client).
> We tried to run all clients in the small four machines network and
> all worked fine, but as we started the 'executor' in one machine all
> the system stopped to work fine and run very slowly. We tryed to run
> the 'executor' in all machines without the client and the problem
> continued. We decided so to change the system spliting each
> equipment with one client and one 'executor'. It runs now but the
> performance was poor. It seems that we cannot have more than one
> connection to firebird working. We decided so to connect and
> disconnect in each SQL request but the performance was the same,
> althoug we could get the client and the 'executor' working together.
> I changed the ibconfig for the best performance due to we have very
> huge equipments installed (Pentium 4 HT with 2.6 Mz and 2 GB of
> memory, plus 120 Gb disk in a Asus high performance motherboard). We
> are using Windows 2000 and only the client and the 'executor' are
> running in the equipments (no MS-Office, graphics software,
> multimidia, etc).
> We are based in a hotel 50 miles from Sao Paulo-Brazil in a hotel
> for the training (we could run 4 section with almost only 50% of the
> simulation tasks due to the performance) without a good Internet
> connection. I come back home today to try to find out a solution due
> to the next simulation section will be next Monday.

I think you need to tell us a bit more about what these systems do.. and
also

1. What version of firebird are you using - superserver or classic?
2. What language is the application written in?
3. What connection suite are you using to talk to the server?

Alan