Skip to content

Backup restore is slow in FB3 when the database contains many small tables with indices [CORE5101] #5385

@firebird-automations

Description

@firebird-automations

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions