Submitted by: michalk1 (michalk1)
Attachments:
Fb25Gbk.zip
Fb30Gbk.zip
restore-benchmark_fb25-vs-fb30_-_tables_1e3__indices_1e4.zip
create-table-with-NN-indices-benchmark-FB-25_vs_30__fw_OFF_maxunflushed_minus_1.rar
Let's have a database with 1000 simple empty tables
CREATE TABLE TABn (ID INTEGER PRIMARY KEY)
The gbk restore time (without verbose switch) of the database is 15 seconds in FB2.5 vs 2 minutes in FB3 RC1. When run in verbose mode, it shows that FB3 gbak spends too much time in "activating and creating deferred index" lines phase.
Commits: 0719958 FirebirdSQL/fbt-repository@d26c94d
Submitted by: michalk1 (michalk1)
Attachments:
Fb25Gbk.zip
Fb30Gbk.zip
restore-benchmark_fb25-vs-fb30_-_tables_1e3__indices_1e4.zip
create-table-with-NN-indices-benchmark-FB-25_vs_30__fw_OFF_maxunflushed_minus_1.rar
Let's have a database with 1000 simple empty tables
CREATE TABLE TABn (ID INTEGER PRIMARY KEY)
The gbk restore time (without verbose switch) of the database is 15 seconds in FB2.5 vs 2 minutes in FB3 RC1. When run in verbose mode, it shows that FB3 gbak spends too much time in "activating and creating deferred index" lines phase.
Commits: 0719958 FirebirdSQL/fbt-repository@d26c94d