Subject Re: Firebird is slower on multicpu Window box then single cpu
Author tsttang
Hi Aage,
There are some java process to aggregate the data before they are
being inserted. With the same data and the same java program, I
loaded the data into Firebird on a single cpu machine and it tooks
only 50 seconds. When I did the same thing but connect to a multicpu
box in the same network domain, it took 3 minutes. I have tried
switching HT off and that does not make any difference. The same
test is done against Oracle in the two different environment and
there is no timing degration on the multi-cpu box. I will try
setting the cpu affinity and see if it makes a difference.

--- In, Aage Johansen
<aagjohan@o...> wrote:
> tsttang wrote:
> >
> >
> > I have installed firebird database on a multicpu machine
> > with win2k server or window 2003 server. In either
> > case, the performance is much slower than the firebird
> > database I installed on a single cpu box with window
> > 2000 server or window 2000 professional. The
> > multicpu box has 2 GB memory, two 2.2 Ghz pentium 4
> > cpu. The harddisk performance is faster than the single
> > cpu box. The single cpu box has one single cpu, 2.2
> > Ghz pentium 4 and 2 GB memory. I have tried firebird
> > 1.03 and 1.5.1 in super server configuration. I have
> > also tried 1.5.1 in classic server configuration in the
> > dual cpu box but the result is the same. In all cases,
> > the performance of the database is about three to four
> > times slower than on a single cpu box. The test is to
> > load 20000 records into the database using a java
> > program with jaybird as its jdbc driver.
> How long does it take? Inserting 20000 records is probably of the
order of
> 5 secs or less - maybe not easy to time correctly. Also,
TaskManager may
> not be the greatest tool for close monitoring.
> Could you disable HT (in the BIOS), and try once more? I've moved
> database from an old/slow PII machine (WinNT, Fb/0.9?) to a modern
> machine (Win2k, Fb/1.5) and experienced a very nice performance
> - about 20X, I think. Of course, the newer box had more RAM and
> disks as well. HT off, and Fb affinity set to one cpu.
> I'm shortly going to move some database from Win2000 to Win2003,
> cpus and more ram - I'm really interested in your experiences.
> --
> Aage J.