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
Operations

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: 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
 

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