Improve performance of JQL based Advanced Roadmaps plans

XMLWordPrintable

      Context

      There are three issue sources in Advanced Roadmaps plans, namely projects, boards (which effectively use the board's JQL filter), and saved filters (which use custom JQL queries). This improvement focuses on optimizing the performance of the latter two JQL-based sources.

      Change

      Before this change, Advanced Roadmaps would perform a full issue search, loading complete issue objects. Now, Advanced Roadmaps uses Lucene collectors to fetch only the necessary data.

      Results

      In our internal testing on large-scale plans with complex JQL queries, this improvement made affected plans load up to two times faster.

      However, it's worth noting that Advanced Roadmaps contain optimizations for simple JQL queries. These optimizations allow it to determine plan data without executing the query, meaning some plans will not be affected by this improvement. An example would be a query like "project = JSWSERVER and issueType = Bug", where it's certain that all issues in the plan will come from the JSWSERVER project. This change mainly benefits plans with complex JQL queries, where these optimizations can't be applied.

              Assignee:
              Daniel Rauf
              Reporter:
              Daniel Rauf
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: