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.
Yesterday something very strange happened. I tryed to test the
client in another equipment with Windows XP with Firebird in my
local machine. When connecting to the
database "localhost:c:\database\simulator.gdb" I found out that the
time for the connection was very high (20 seconds or more). changing
to a remote connection "othermachinename:c:\database\simulator.gdb"
the connection was very fast (1 sec or less). I could not find the
reason for that and will try today at home to find it out.
Is there some paperwork, documentation, personal experiences that
you could share with me to solve this huge Firebird new user problem?
Thank you very much and my apologies for writing so much.

Wagner Bazarin
wagner@...
Sao Paulo
Brasil