Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-13204

Browsing projects is slow on large instances

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.3
    • Component/s: ElasticSearch
    • Labels:
    • Edition:
      Community
    • Production Notes:
      None

      Description

      List of projects on "Projects" page can be slow to display.

      At least:

      • its not instantaneous compared to the number of projects displayed
      • it can be noticeably long to display results when enabling more facets

      WS api/components/search_projects (internal) is providing the content of these pages.

      Looking at some traces in dev from "Projects" page, out of 265ms (see details as comments):

      1. 185ms is spent querying ES
      2. 58ms is spent retrieving user's favourites from DB (??!!)
      3. 13ms in other SQL requests

      After some investigations, it appeared that:

      1. removal of "global()" aggregation did improve the performance but wasn't the only cause of slowness
      2. quick look at profiling seem to indicate Lucene requests are numerous and a bit costly

        Attachments

          Activity

            People

            Assignee:
            jacek.poreda Jacek Poreda
            Reporter:
            julien.lancelot Julien Lancelot
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: