Management of workflow since the introduction of artifact based post actions is slow. A basic workflow on 4 values (4x4 transitions) can lead to 1900+ SQL queries at display and 800+ queries at write (artifact update). This commit solves this perf issue with 2 strategies: - caching of the already computed values. Some may argue it hides the underlying problem but given the current architecture of the tracker it's hard to do it without an entire rebuild of the way fields are managed. - pre-fetching of the values. The code is desgined after fetching of single transitions. However, most of the time we need to fetch the entire worfklow (all transitions, all post actions, etc) so it's more efficient to fetch everything at once. With this patch, an artifact web view display went from 1870 SQL queries to 299 (for the record, same artifact without workflow requires 278 SQL queries) and update from 311 to 150. Fix request #17191 Artifacts in trackers with workflow generate way to much SQL requests Change-Id: Id793411db456cd905efcb109797df42b27fb58ce

+870 −538

Author

Manuel Vacelet (vaceletm) 2020-10-09 11:54

Committer

Manuel Vacelet (vaceletm) 2020-10-19 11:53

Hash 8ae7e858999265b335f6fd32e186d271e9254bad

Parent 10b4f046c733be6b503ac7edfc2f1e3f0e2e29d6

Reference git #tuleap/stable/8ae7e858999265b335f6fd32e186d271e9254bad