Subject Performance Issues with Firebird 2.01 64 Bit
Author Dalton Calford
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