Page MenuHomePhabricator

[Task] Use diff information to optimize database updates when saving an entity
Open, HighPublic

Description

Checking/updating secondary tables when saving entities can be costly. Much of this could be avoided if we could use information what exactly changed about an entity, instead of just saving all information about it afresh, as if it did not exist before.

Information about what exactly was changed about an entity already exists further up the stack of the save operation: EditEntity has a diff, and even before that, we often have ChangeOps. If we could loop this information through to the point where it could be used to optimize database access, that would be quite helpful.

Details

Reference
bz57750

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:30 AM
bzimport set Reference to bz57750.
bzimport added a subscriber: Unknown Object (MLST).
Lydia_Pintscher removed a subscriber: Unknown Object (MLST).
Lydia_Pintscher removed a subscriber: Unknown Object (MLST).
thiemowmde renamed this task from Use diff information to optimize database updates when saving an entity. to [Task] Use diff information to optimize database updates when saving an entity.Aug 13 2015, 4:53 PM
thiemowmde updated the task description. (Show Details)
thiemowmde set Security to None.
thiemowmde removed a subscriber: Wikidata-bugs.