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
