Subject | Performance Issues with Firebird 2.01 64 Bit |
---|---|
Author | Dalton Calford |
Post date | 2007-08-01T18:59Z |
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
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