Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Configuration Properties | Database Query Properties | tn.query.threshold
 
tn.query.threshold
Number of rows of query results to store in the session object; storing query results in the session object optimizes query execution. Trading Networks stores the number of rows you specify in the session object on the host Integration Server and uses the caching component to store the remaining rows of query results in Ehcache.
Trading Networks uses this property for all queries you perform from My webMethods (for example, queries for documents, tasks, and activity logs). In addition, this is the default for queries that you perform using the built-in services in the wm.tn.query folder.
If you are using Trading Networks in a cluster, do not store query results in the session object; set this property to -1. If you are not using Trading Networks in a cluster, for best performance, set this property to be the page size Trading Networks uses for query results (that is, 50). The default is 50.