Catastrophic slowdown in isql in Firebird 3 compared to Firebird 2.5 under Linux
--------------------------------------------------------------------------------
Key: CORE-5668
URL: http://tracker.firebirdsql.org/browse/CORE-5668
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0.2
Environment: Debian amd64, local only (no server)
Reporter: Vadim Zeitlin
Attempting to switch to using Firebird 3 I realized that creating our database,
i.e. just executing "CREATE TABLE" basically, now takes 4.5 *minutes* when it
previously took 1.5 *seconds* under Linux. The problem can be even seen with
completely trivial example such as this one:
CREATE DATABASE 'test.fdb';
CREATE TABLE t_01 (id CHAR(3));
CREATE TABLE t_02 (id CHAR(3));
CREATE TABLE t_03 (id CHAR(3));
CREATE TABLE t_04 (id CHAR(3));
CREATE TABLE t_05 (id CHAR(3));
CREATE TABLE t_06 (id CHAR(3));
CREATE TABLE t_07 (id CHAR(3));
CREATE TABLE t_08 (id CHAR(3));
CREATE TABLE t_09 (id CHAR(3));
CREATE TABLE t_10 (id CHAR(3));
Running "isql-fb -q -b -i test.sql" with this file takes less than 0.1s with
Firebird 2.5 but almost 3.5s with Firebird 3.0.3. I thought there was something
wrong with the version provided by Debian (3.0.2.32703.ds4-11), but the version
I compiled myself from the latest B3_0_Release branch sources shows the same
behaviour. However this is definitely Linux-specific as under Windows Firebird
3 is as fast or faster than 2.5.
This basically makes Firebird unusable even for our very modest needs, fully
populating the database with data took a long time (hours) even with Firebird
2.5, I won't even be able to test it with Firebird 3.
Is there anything particularly stupid I'm doing here or could the performance
really degrade that badly? Looking at perf output, there is nothing especially
jarring, although it is surprising that ~4% of total time is spent in
Firebird::MemPool::allocate and another 2% in Firebird::MemPool::release.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
