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




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
>