topic Re: What does &quot;wt.pom.rowPrefetchCount&quot; mean? in Windchill Customization https://www.ptcusercommunity.com/t5/Windchill-Customization/What-does-quot-wt-pom-rowPrefetchCount-quot-mean/m-p/406896#M7167 <HTML><HEAD></HEAD><BODY><P>You can get information about properties if you visit the following URL:</P><P><A href="http://pds.steelcase.com/Windchill/properties.html" title="http://pds.steelcase.com/Windchill/properties.html">http://&lt;Your Windchill URL&gt;/Windchill/properties.html</A></P><P></P><P>This is what it says for the property <SPAN style="color: #000000; font-family: 'Times New Roman'; font-size: medium;">wt.pom.rowPrefetchCount </SPAN></P><TABLE border="1" cellpadding="2" style="color: #000000; font-family: 'Times New Roman'; font-size: medium;"><TBODY><TR><TD valign="top">wt.pom.rowPrefetchCount </TD><TD valign="top"><STRONG>Default:</STRONG> 20<BR /><STRONG>Synopsis:</STRONG> JDBC driver tuning parameter that specifies the number of rows to pre-fetch when reading result sets. <BR /><STRONG>Description:</STRONG> This property can reduce the amount of communication between the method server and the database. However, JDBC drivers may pre-allocate memory for the prefetched rows so there is a potential negative performance impact if the value is too high. </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 04 Oct 2016 19:10:03 GMT jmomber 2016-10-04T19:10:03Z What does "wt.pom.rowPrefetchCount" mean? https://www.ptcusercommunity.com/t5/Windchill-Customization/What-does-quot-wt-pom-rowPrefetchCount-quot-mean/m-p/406895#M7166 My question is in the title.Thanks for help. Fri, 15 Mar 2024 15:00:37 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/What-does-quot-wt-pom-rowPrefetchCount-quot-mean/m-p/406895#M7166 tprud'homme 2024-03-15T15:00:37Z Re: What does "wt.pom.rowPrefetchCount" mean? https://www.ptcusercommunity.com/t5/Windchill-Customization/What-does-quot-wt-pom-rowPrefetchCount-quot-mean/m-p/406896#M7167 <HTML><HEAD></HEAD><BODY><P>You can get information about properties if you visit the following URL:</P><P><A href="http://pds.steelcase.com/Windchill/properties.html" title="http://pds.steelcase.com/Windchill/properties.html">http://&lt;Your Windchill URL&gt;/Windchill/properties.html</A></P><P></P><P>This is what it says for the property <SPAN style="color: #000000; font-family: 'Times New Roman'; font-size: medium;">wt.pom.rowPrefetchCount </SPAN></P><TABLE border="1" cellpadding="2" style="color: #000000; font-family: 'Times New Roman'; font-size: medium;"><TBODY><TR><TD valign="top">wt.pom.rowPrefetchCount </TD><TD valign="top"><STRONG>Default:</STRONG> 20<BR /><STRONG>Synopsis:</STRONG> JDBC driver tuning parameter that specifies the number of rows to pre-fetch when reading result sets. <BR /><STRONG>Description:</STRONG> This property can reduce the amount of communication between the method server and the database. However, JDBC drivers may pre-allocate memory for the prefetched rows so there is a potential negative performance impact if the value is too high. </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 04 Oct 2016 19:10:03 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/What-does-quot-wt-pom-rowPrefetchCount-quot-mean/m-p/406896#M7167 jmomber 2016-10-04T19:10:03Z