Page MenuHomePhabricator
Create Task
Maniphest T5476

Move workboard relationships to a dedicated (non-edge) table
Closed, ResolvedPublic
Actions

Description

There are two issues with the current edge-based storage:

  • The relationship is three-legged: <projectPHID, columnPHID, objectPHID>. If we have a task and a list of projects, we can not efficiently load the columns that task is in. Instead, we have to load all columns the task is in, or all columns those projects have. Both queries are potentially explosive in terms of the number of objects returned.
  • We don't have anywhere to store ordering for the "keep things where I put them" ordering in T4807.

Revisions and Commits

rP Phabricator
D10160rP09868271bdce Move board relationships to dedicated storage
D9832rPfae23e086049 Make column reordering after edits on workboards more general

Related Objects
Search...

Event Timeline

epriestley created this task.Jun 25 2014, 1:01 PM
epriestley raised the priority of this task from to Normal.
epriestley updated the task description. (Show Details)
epriestley added a project: Workboards.
epriestley added a subscriber: epriestley.
epriestley edited this Maniphest Task.Jun 25 2014, 1:01 PM
simsekburak added a subscriber: simsekburak.EditedJun 25 2014, 5:10 PM

Sorry for the spam but phabricator is amazing!

epriestley claimed this task.Jun 25 2014, 7:39 PM
epriestley moved this task to Workboards v1 on the Workboards board.
epriestley edited this Maniphest Task.Jul 5 2014, 7:24 PM
epriestley edited this Maniphest Task.Jul 5 2014, 7:44 PM
epriestley edited this Maniphest Task.Jul 10 2014, 5:19 PM
epriestley added a revision: D10160: Move board relationships to dedicated storage.Aug 5 2014, 11:08 PM
epriestley added a subscriber: swisspol.Aug 6 2014, 10:08 PM

@swisspol, as our #1 workboards tester, let me know if you see anything suspicious after you pick up this change. This is expected to have no visible effects, but paves the way for fixing T4807.

epriestley closed this task as Resolved.Aug 6 2014, 10:09 PM
epriestley added a commit: rP09868271bdce: Move board relationships to dedicated storage.

Closed by commit rP09868271bdce.

epriestley added a comment.Aug 6 2014, 10:10 PM

This live on this install now.

btrahan closed subtask T5245: Migrate Maniphest Projects to use edge infrastructure as Resolved.Dec 22 2014, 7:54 PM
Phabricator · Built by Phacility