Performance regression when restoring database with big metadata [CORE2634] #3042
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
component: engine
fix-version: 2.1.4
fix-version: 2.5 RC1
priority: major
type: bug
Submitted by: @AlexPeshkoff
Relate to CORE3079
Restore of metadata only backup for database with about 100 000 records in RDB$FIELDS runs approximately 20-25 times longer on 2.X compared with 1.5.
According to Dmitry, the reason is new type of deferred work, added in 2.0, which is posted after any insert of the record into RDB$FIELDS table. Time is wasted when workign with DFW is stored in linear linked list.
Commits: b19dace d1d8b30 57b4001
The text was updated successfully, but these errors were encountered: