Database Write Tuning Options for Cache Aside
Various properties affect how database operations in each RTC transaction are processed and committed to the backing store.
These properties affect the way RTC actions are processed and written to the database when both of these settings are used:
Note: Tuning the parameters in this section can improve performance. However larger values do not imply improved performance. For example, in heavy workload situations, increasing
dbOpsBatchSize and
dbOpsQueueSize values results in longer post-RTC times, which in turn delays release of cache locks — which are not released until after the post-RTC
- Database Write Queue and Thread Pool (Agent Level)
Actions for one or more RTCs are done in one or more batches, depending on tuning options. - Database Batching Option (Cluster Level)
All RTC transactions in one batch can be handled as one job (in agents that have the property set to a number larger than one) depending on the cluster-level property setup.
Copyright © TIBCO Software Inc. All rights reserved.