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

ComputationStepExecutor: "Load quality profiles" is slow to load the QP content

    XMLWordPrintable

    Details

      Description

      Context: Java and JS Plugin, MS SQL 2012, Empty DB

      2015.10.06 15:06:34 TRACE [o.s.s.c.c.ComputeEngineContainerImpl] PicoContainer: instantiated org.sonar.server.computation.step.LoadQualityProfilesStep(org.sonar.server.computation.batch.BatchReportReader, org.sonar.server.computation.qualityprofile.ActiveRulesHolderImpl, org.sonar.server.computation.issue.RuleRepository) [0 ms], component org.sonar.server.computation.step.LoadQualityProfilesStep, injected [org.sonar.server.computation.batch.BatchReportReaderImpl, org.sonar.server.computation.qualityprofile.ActiveRulesHolderImpl, org.sonar.server.computation.issue.RuleRepositoryImpl]
      2015.10.06 15:06:34 TRACE [sql] time=27ms | sql=SELECT         r.id,    r.plugin_rule_key as "ruleKey",    r.plugin_name as "repositoryKey",    r.description,    r.description_format as "descriptionFormat",    r.status,    r.name,    r.plugin_config_key as "configKey",    r.priority as "severity",    r.is_template as "isTemplate",    r.language as "language",    r.template_id as "templateId",    r.note_data as "noteData",    r.note_user_login as "noteUserLogin",    r.note_created_at as "noteCreatedAt",    r.note_updated_at as "noteUpdatedAt",    r.characteristic_id as "subCharacteristicId",    r.default_characteristic_id as "defaultSubCharacteristicId",    r.remediation_function as "remediationFunction",    r.default_remediation_function as "defaultRemediationFunction",    r.remediation_coeff as "remediationCoefficient",    r.default_remediation_coeff as "defaultRemediationCoefficient",    r.remediation_offset as "remediationOffset",    r.default_remediation_offset as "defaultRemediationOffset",    r.effort_to_fix_description as "effortToFixDescription",    r.tags as "tagsField",    r.system_tags as "systemTagsField",    r.created_at as "createdAt",    r.updated_at as "updatedAt"       FROM rules r WHERE r.plugin_name=? AND r.plugin_rule_key=?
      2015.10.06 15:06:34 TRACE [sql] time=27ms | sql=SELECT         r.id,    r.plugin_rule_key as "ruleKey",    r.plugin_name as "repositoryKey",    r.description,    r.description_format as "descriptionFormat",    r.status,    r.name,    r.plugin_config_key as "configKey",    r.priority as "severity",    r.is_template as "isTemplate",    r.language as "language",    r.template_id as "templateId",    r.note_data as "noteData",    r.note_user_login as "noteUserLogin",    r.note_created_at as "noteCreatedAt",    r.note_updated_at as "noteUpdatedAt",    r.characteristic_id as "subCharacteristicId",    r.default_characteristic_id as "defaultSubCharacteristicId",    r.remediation_function as "remediationFunction",    r.default_remediation_function as "defaultRemediationFunction",    r.remediation_coeff as "remediationCoefficient",    r.default_remediation_coeff as "defaultRemediationCoefficient",    r.remediation_offset as "remediationOffset",    r.default_remediation_offset as "defaultRemediationOffset",    r.effort_to_fix_description as "effortToFixDescription",    r.tags as "tagsField",    r.system_tags as "systemTagsField",    r.created_at as "createdAt",    r.updated_at as "updatedAt"       FROM rules r WHERE r.plugin_name=? AND r.plugin_rule_key=?
      ...
      ...
      ...
      2015.10.06 15:08:07 TRACE [sql] time=29ms | sql=SELECT         r.id,    r.plugin_rule_key as "ruleKey",    r.plugin_name as "repositoryKey",    r.description,    r.description_format as "descriptionFormat",    r.status,    r.name,    r.plugin_config_key as "configKey",    r.priority as "severity",    r.is_template as "isTemplate",    r.language as "language",    r.template_id as "templateId",    r.note_data as "noteData",    r.note_user_login as "noteUserLogin",    r.note_created_at as "noteCreatedAt",    r.note_updated_at as "noteUpdatedAt",    r.characteristic_id as "subCharacteristicId",    r.default_characteristic_id as "defaultSubCharacteristicId",    r.remediation_function as "remediationFunction",    r.default_remediation_function as "defaultRemediationFunction",    r.remediation_coeff as "remediationCoefficient",    r.default_remediation_coeff as "defaultRemediationCoefficient",    r.remediation_offset as "remediationOffset",    r.default_remediation_offset as "defaultRemediationOffset",    r.effort_to_fix_description as "effortToFixDescription",    r.tags as "tagsField",    r.system_tags as "systemTagsField",    r.created_at as "createdAt",    r.updated_at as "updatedAt"       FROM rules r WHERE r.plugin_name=? AND r.plugin_rule_key=?
      2015.10.06 15:08:07 INFO  [o.s.s.c.s.ComputationStepExecutor] Load quality profiles | time=92675ms
      

        Attachments

          Activity

            People

            Assignee:
            julien.lancelot Julien Lancelot
            Reporter:
            alexandre.gigleux Alexandre Gigleux
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: