Issue Details (XML | Word | Printable)

Key: CORE-2634
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Alexander Peshkov
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

Performance regression when restoring database with big metadata

Created: 17/Sep/09 11:32 PM   Updated: 18/Jan/16 06:02 PM
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

Environment: Any
Issue Links:

QA Status: No test

 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   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.