diff options
| author | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-02-26 16:47:54 +0100 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-02-29 12:12:16 +0100 |
| commit | cbf142857bfce52b0131ade69ce34880f813f2e7 (patch) | |
| tree | 2294fe7aa748c156662b12a3e3ce13ee35fd76dc /sonar-db/src/main/resources/org/sonar/db/loadedtemplate | |
| parent | afe276c062e03d7c0ed7bab97b0ee8cf0511423e (diff) | |
| download | sonarqube-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.xml | 2 |
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> |