stable
Clone or download
Read-only
request #9854: Improve performance of "Submit new artifact" rendering
With a workflow transition matrix based on 12 values in Status field, we perform (more than) 12 * 13 SQL requests to retrieve the transition, whereas we can retrieve all transitions in 1 request and cache the result. With this commit here are the gain on my setup: time: -21% (396 ms → 314 ms) io wait: -35% (158 ms → 102 ms) cpu: -11% (239 ms → 212 ms) memory: -1% (16.8 MB → 16.7 MB) sql queries: -40% / -321rq (136ms → 82.4ms / 745rq → 424rq) Change-Id: Ida168497a76e3937e50dfb511ba38eace14d1d6a
Modified Files
| Name | ||||
|---|---|---|---|---|
| M | plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_List.class.php | +2 | −2 | Go to diff View file |
| M | plugins/tracker/include/workflow/TransitionFactory.class.php | +17 | −16 | Go to diff View file |
| M | plugins/tracker/include/workflow/Workflow_TransitionDao.class.php | +25 | −21 | Go to diff View file |