B2B Integration 10.5 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Caching Assets and Query Results | Query Results Caching
 
Query Results Caching
Trading Networks stores the results of a database query in a session object to optimize query execution. Trading Networks uses the tn.query.threshold property for all queries you perform from My webMethods. The number of rows stored in the session object depends on the value you set for this property. The remaining rows are stored in the TNQueryResults cache. For best performance, set this property to be the page size Trading Networks uses for query results (that is, 50). The remaining rows are stored in the cache.

Copyright © 2016- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.