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

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

    XMLWordPrintable

    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

          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: