Hello friends,

I have a strange performance problem with fb 2.5.X. My friend told me
that a program that he uses is working faster when database is on
Windows XP compared to database on Linux. I didn't believe and did some
tests. I can't explain the results to myself. For the tests I've used
DemoDB from IBExpert. On every test, I've created new DB using a script
provided in IBExpert. After the DB is created, I run a procedure and
wait to finish. The tests were made on different virtual machine on
VirtualBox Host. The host is Intel i3 2100T with 4GB DDR3 RAM and raid 5
array(linux software raid). Every virtual machine i've created was with
similar parameters. 1GB RAM, 8GB HDD The results are:

1. Windows XP SP3 - FB Superserver 2.5.last - DB created in 10 sec.
Execution of procedure 1 min 30 sec
2. Linux Slackware 32 bit FB Superserver 2.5.last - DB created in 11
sec. Execution of procedure 2 min 47 sec
3. Linux Slackware 64 bit FB Superserver 2.5.last-compiled by me - DB
created in 10,4 sec. Execution of procedure 2 min 30 sec
4. Linux Slackware 64 bit FB Superserver 2.5.last-compiled by me. DB is
in 512MB ramdisk - DB created in 7 sec. Execution of procedure 1 min 47 sec
5. Linux Debian 6.0.4 32 bit - FB Superserver 2.5.last - DB created in
11 sec. Execution of procedure 2 min 47 sec

I can't explain to myself, why on linux the performance is so different
vs Windows XP.

Any explanation is welcome.

Thanks in advance.

Regards,
Ivaylo M. Ivanov