topic Re: JDBC Fetch size in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298874#M252004 <HTML><HEAD></HEAD><BODY><A href="http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/" rel="nofollow noopener noreferrer">http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/</A><BR /><BR /><SPAN>The article above says no impact for MS SQL Server.&nbsp;&nbsp;&nbsp;&nbsp; That parameter seems to be important for ORACLE database only.</SPAN></BODY></HTML> Tue, 03 Mar 2015 13:54:00 GMT mrogers 2015-03-03T13:54:00Z JDBC Fetch size https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298873#M252003 Does this have any effect on 4.2.4 with MS SQL DB?On our production system we have an oracle DB with hibernate.jdbc.fetch_size=150 (v4.2.3), and I wondered if this would have a beneficial impact on our 4.2.4 setup…Again, I cannot find anything online about the jdbc.fetch_size for MS SQL !I extend my Mon, 02 Mar 2015 17:47:49 GMT https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298873#M252003 t16 2015-03-02T17:47:49Z Re: JDBC Fetch size https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298874#M252004 <HTML><HEAD></HEAD><BODY><A href="http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/" rel="nofollow noopener noreferrer">http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/</A><BR /><BR /><SPAN>The article above says no impact for MS SQL Server.&nbsp;&nbsp;&nbsp;&nbsp; That parameter seems to be important for ORACLE database only.</SPAN></BODY></HTML> Tue, 03 Mar 2015 13:54:00 GMT https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298874#M252004 mrogers 2015-03-03T13:54:00Z Re: JDBC Fetch size https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298875#M252005 <HTML><HEAD></HEAD><BODY><SPAN>Thank you so much for your help Mrogers, its really appreciated.</SPAN><BR /><BR /></BODY></HTML> Wed, 04 Mar 2015 21:52:27 GMT https://connect.hyland.com/t5/alfresco-archive/jdbc-fetch-size/m-p/298875#M252005 t16 2015-03-04T21:52:27Z