Tuning Database Channel Queue Size
The DB channel queue size is a setting that specifies the number of buffers within the TDV Server for a client request to prefetch from the database. By default this value is set to 0. If set to 1, the TDV Server can prefetch from the database and put it in a buffer to store it while the TDV JDBC driver is still fetching data from the TDV Server. When the TDV JDBC client asks for the next batch, it is already available in the buffer.
Value | Description of Behavior |
1 | Data is prefetched and stored in a buffer. |
0 | Data is only fetched when the client requests it. |
To tune database channel queue size
1. Open and log into Studio.
2. From the Administration menu, choose Configuration.
3. Navigate to Server > Client Drivers > Performance.
4. Select DbChannel Queue Size.
5. Specify 0 or 1.