[#CORE-2634] Performance regression when restoring database with big metadata

Firebird Core

Performance regression when restoring database with big metadata

Created: 17/Sep/09 11:32 PM Updated: 26/Jul/10 10:56 AM

Component/s:

Engine

Affects Version/s:

2.0.0, 2.0.1, 2.0.2, 2.0.3, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2

Fix Version/s:

2.5 RC1, 2.1.4

Time Tracking:

Not Specified

Environment:

Any

Issue Links:

Relate

This issue relate to:

~~CORE-3079~~ Strong slowing down inserts with EVENT-s in a single transaction.

Planning Status:

Unspecified

Description

« Hide

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.

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

There are no comments yet on this issue.