--- In firebird-support@yahoogroups.com, Aage Johansen
<aagjohan@o...> wrote:

> On Tue, 30 Dec 2003 10:47:46 +0000 (UTC), bazarin wrote:
>
> > We are using FB 1.5 to run an application to simulate Business

situation

> > and found out a very strange performance situation that

introduced a

> > bottleneck in our project.
> > We are using the following:
> > 1) A network with 5 computers (running at 100 Mb network)
> > 2) One of the microcomputers in the network is a database server

without

> > other usage.
> > 3) All computers are Pentiun 4 2.4 HT. All have 1Gb of memory

and 80 Gb

> > hard-drive.
> > 4) We are using windows 2000 with the current Microsoft Service

Pack

> > installed.
> > 5) No other application but the simulation are running in the

system.

> > 6) The application were developed with Delphi 6 and DBExpress.
> > ...
>
>
> Try to turn HT _off_ for the pc running the Fb server (you're using

FB

> SuperServer, aren't you?).
>
>
> --
> Aage J.

Thank you Aage! Yes, I am using the SuperServer.

I did the changes in the FB configuration file as below:

CpuAffinityMask=1
DefaultDbCachePages=10240
EventMemSize=655360
LockRequireSpins=0
DeadThreadsCollection=50

These are the changes done from the default configuration.

We runned the application again, first with one client (it last 2:22
minutes) and with the all 4 clients that last 9:10 minutes. It seems
that changing the CpuAffinityMask from 3 to 1 the total time
increased instead.

Regards,

Wagner