Subject [firebird-support] Performance Issues with Firebird 2.01 64 Bit - Followup information
Author Dalton Calford
To continue with this thread - I have been performing a series of tests.

Test platform

2x Quad Core Xeon Processor 2.33Ghz
16 GB Ram (667 MHz.)
4x 73 GB 15K rpm Serial Attach SCSI - 3 Gbps Harddrives

OS - Fedora Core 7 32 bit and 64 bit

Test Database - a small 28GB database, with only three tables. Data
has natural primary keys - two indexes per table
All restore operations are coming from a single gbak file in
transportable format.

Firebird libraries set to client instead of embed.

Firebird 2.01 32 bit and 64 bit, Firebird 1.53 32 bit

Fedora 64 Bit, Firebird 2 64 Bit

gbak -c backup.gbak /home/fb/restore1.001 -page_size 16384 -bu 10000 -v
-y restore1.out
Total time for the restore - 5 hours 8 minutes
gbak -c backup.gbak localhost:/home/fb/restore2.001 -user SYSDBA
-password masterkey -page_size 16384 -bu 10000 -v -y restore2.out
Total time for the restore - 11 hours, 19 minutes

Fedora 64 Bit, Firebird 2, 32 Bit
gbak -c backup.gbak /home/fb/restore3.001 -page_size 16384 -bu 10000 -v
-y restore3.out
Total time for the restore -

gbak -c backup.gbak localhost:/home/fb/restore4.001 -user SYSDBA
-password masterkey -page_size 16384 -bu 10000 -v -y restore4.out
Total time for the restore - 11 hours, 37 minutes

Fedora 64 Bit, Firebird 1.53, 32 Bit
gbak -c backup.gbak /home/fb/restore5.001 -page_size 16384 -bu 10000 -v
-y restore5.out
Total time for the restore - 3 hours 49 minutes

gbak -c backup.gbak localhost:/home/fb/restore6.001 -user SYSDBA
-password masterkey -page_size 16384 -bu 10000 -v -y restore6.out
Total time for the restore - 4 hours, 11 minutes

I am currently formating up the machine for windowsXP, and I will
perform the exact same tests.

It appears that the fb_inet_server process is much slower in generating
indexes than gbak is.
I monitored the process and very little CPU bouncing was going on - the
fb_inet_server process remained on the same CPU for the whole process
while the gbak process rarely jumped cpu's

Has anyone else encountered issues like this?

best regards


Dalton Calford wrote:
> I am currently testing firebird 2 and I have found a number of issues
> with speed in comparison to firebird 1.53.
> I have even found a number of issues just comparing local connections vs
> remote connections.
> What I would like to know is if there are any known issues with Firebird
> 2 in regards to performance?
> I have many examples of performance problems, such as a database that
> Firebird 1.53 32bit, running on a 64 bit Linux kernel, takes 3 hours and
> 18 minutes to restore, via localhost:/path_ to_database whereas the exact
> same gbak file, takes 11 hours and 19 minutes to restore with the exact
> same parameters on Firebird 2.01 64 bit.
> Running a variety of queries via isql shows that the 32 bit 1.53 version
> is much faster than the 2.01 64 bit version.
> Is this a problem with 64 bit Firebird? Are there any significant
> changes that I must deal with in order to get the performance with 2.01?
> Thanks in advance
> Dalton