Wagner Bazarin wrote:

> > 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).

"Alan McDonald" replied:

> 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?

Also, give us some database statistics, like Oldest Active
Transaction, Next Transaction, database size and index selectivity.
Maybe even a bit of SQL. And what do you mean by 'slow'? Often,
perceived slowness is due to wrong use of transactions, wrong indexes
or SQL or using Firebird as if it was a desktop database/spreadsheet.
However, if you require more than e.g. 10000 rows per second or have
some very demanding calculation, then it may also be that Firebird may
have problems fulfilling your expectations.

Set