--- In firebird-support@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:

> 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

Thank you!
I will come back to the hotel next Monday morning, collect all
information and will send to you. My apologies for answering late.
Regards,

Wagner