User Guide > TDV Query Engine Optimizations > Performance Configuration Parameter Tips from an Expert
 
Performance Configuration Parameter Tips from an Expert
When using several of the TDV performance enhancement features, such as caching and the data ship options, some of the values for the configuration parameters can create a conflict. In particular, pay attention to:
Configuration Parameter
Description
DBChannel Prefetch Optimization
Improves the performance for read/write operations. By default, this parameter is set to TRUE.
DBChannel Queue Size
Allows you to tune the number of buckets. By default, this parameter is set to 0. The appropriate starting value is 10.
DBChannel Flood Optimization
Setting the Flood Optimization option to True, will enable the Flood protocol to be used in client communications if requested by the client. The default value is True.
Note: It will not be necessary to restart server if this value changed.
Note: If the combination of DBChannel Prefetch Optimization set to TRUE and DBChannel Queue Size set to 1 exists in your environment, new sessions fail to be created after many sessions and requests terminate due to an exception. This is because only 1 prefetch bucket is created. Restarting the TDV may temporarily clear the issue, but it is best to adjust the values of the configuration parameters. Examine your DBChannel Queue Size setting and increase it as appropriate.