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

Speed up creation of new CE tasks by Views or Developer Cockpit

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.2, 5.3
    • Fix Version/s: 5.4
    • Component/s: Compute Engine
    • Labels:
      None

      Description

      When Views or Developer Cockpit plugins are run, they may create a lot of new Compute Engine tasks at once (respectively as many as there is views or developers) and this is currently slow (recently, creating 7500 tasks for developers on Nemo took 2 minutes or more).

      We should be able to improve speed of these use cases by "batching" the creation of new tasks in CeQueue to use batch insert and a single transaction.
      Batch insert would save overhead of doing inserts one by one and using a single transaction will reduce contention on the CE_QUEUE table (which is often polled for new tasks to process and queried by the UI).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sebastien.lesaint Sebastien Lesaint
                Reporter:
                sebastien.lesaint Sebastien Lesaint
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: