diff options
| author | Simon Brandhof <simon.brandhof@sonarsource.com> | 2017-12-19 13:48:31 +0100 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@sonarsource.com> | 2017-12-20 09:24:26 +0100 |
| commit | 8d3f85ca3272be3b99826c86d24dd4ca54ae85ed (patch) | |
| tree | 87437326c6415366a0b2751629355c958835a1be /server/sonar-db-migration/src/main/java/org/sonar | |
| parent | 2022f77214c6456941f10591e435db8ebead08c0 (diff) | |
| download | sonarqube-8d3f85ca3272be3b99826c86d24dd4ca54ae85ed.tar.gz sonarqube-8d3f85ca3272be3b99826c86d24dd4ca54ae85ed.zip | |
SONAR-10210 Fix performance hotspot in DB migration #1267
Diffstat (limited to 'server/sonar-db-migration/src/main/java/org/sonar')
| -rw-r--r-- | server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v60/PopulateAnalysisUuidOnMeasures.java | 5 |
1 files changed, 0 insertions, 5 deletions
diff --git a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v60/PopulateAnalysisUuidOnMeasures.java b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v60/PopulateAnalysisUuidOnMeasures.java index c7eca704768..d68fd020771 100644 --- a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v60/PopulateAnalysisUuidOnMeasures.java +++ b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v60/PopulateAnalysisUuidOnMeasures.java @@ -44,11 +44,6 @@ public class PopulateAnalysisUuidOnMeasures extends DataChange { massUpdate.select("select distinct m.snapshot_id as sId, s.root_snapshot_id as rootSid " + "from project_measures m " + "inner join snapshots s on m.snapshot_id = s.id " + - "where m.analysis_uuid is null " + - "union " + - "select distinct m.snapshot_id as sId, s.root_snapshot_id as rootSid " + - "from project_measures m " + - "inner join snapshots s on m.snapshot_id=s.id " + "where m.analysis_uuid is null" ); massUpdate.update("update project_measures set analysis_uuid=? where snapshot_id = ? and analysis_uuid is null"); |