Skip to main content
T
tprud'homme1-Visitor
1-Visitor
September 30, 2016
Question

What does "wt.pom.rowPrefetchCount" mean?

  • September 30, 2016
  • 1 reply
  • 1364 views

My question is in the title.

Thanks for help.

1 reply

J
jmomber12-Amethyst
12-Amethyst
October 4, 2016

You can get information about properties if you visit the following URL:

http://<Your Windchill URL>/Windchill/properties.html

This is what it says for the property wt.pom.rowPrefetchCount

wt.pom.rowPrefetchCount Default: 20
Synopsis: JDBC driver tuning parameter that specifies the number of rows to pre-fetch when reading result sets.
Description: 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.
    Terms & ConditionsAccessibility statement