aboutsummaryrefslogtreecommitdiffstats
path: root/sonar-db/src/main/resources/org/sonar/db/loadedtemplate
diff options
context:
space:
mode:
authorSimon Brandhof <simon.brandhof@sonarsource.com>2016-02-26 16:47:54 +0100
committerSimon Brandhof <simon.brandhof@sonarsource.com>2016-02-29 12:12:16 +0100
commitcbf142857bfce52b0131ade69ce34880f813f2e7 (patch)
tree2294fe7aa748c156662b12a3e3ce13ee35fd76dc /sonar-db/src/main/resources/org/sonar/db/loadedtemplate
parentafe276c062e03d7c0ed7bab97b0ee8cf0511423e (diff)
downloadsonarqube-cbf142857bfce52b0131ade69ce34880f813f2e7.tar.gz
sonarqube-cbf142857bfce52b0131ade69ce34880f813f2e7.zip
Replace SQL "count(*)" by "count(1)"
It can have slight performance improvements on some databases.
Diffstat (limited to 'sonar-db/src/main/resources/org/sonar/db/loadedtemplate')
-rw-r--r--sonar-db/src/main/resources/org/sonar/db/loadedtemplate/LoadedTemplateMapper.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/sonar-db/src/main/resources/org/sonar/db/loadedtemplate/LoadedTemplateMapper.xml b/sonar-db/src/main/resources/org/sonar/db/loadedtemplate/LoadedTemplateMapper.xml
index 0395aad517a..09ba1c86d4c 100644
--- a/sonar-db/src/main/resources/org/sonar/db/loadedtemplate/LoadedTemplateMapper.xml
+++ b/sonar-db/src/main/resources/org/sonar/db/loadedtemplate/LoadedTemplateMapper.xml
@@ -10,7 +10,7 @@
</resultMap>
<select id="countByTypeAndKey" parameterType="map" resultType="int">
- SELECT count(*)
+ SELECT count(1)
FROM loaded_templates
WHERE kee = #{key} AND template_type = #{type}
</select>