From 724cf4fa763199ea4a0c04d9596cdbc73070b554 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Tue, 11 Jul 2017 10:08:37 +0200
Subject: [PATCH] SONAR-9216 Memory hotspot when indexing components at server
 startup

---
 .../main/resources/org/sonar/db/component/ComponentMapper.xml   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
index 2138cca83cd..eb361e3a45d 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
@@ -417,7 +417,7 @@
     </if>
   </sql>
 
-  <select id="selectForIndexing" parameterType="map" resultType="Component">
+  <select id="selectForIndexing" parameterType="map" resultType="Component" fetchSize="${_scrollFetchSize}" resultSetType="FORWARD_ONLY">
     select
       <include refid="componentColumns"/>
     from projects p
-- 
2.39.5