Installation guide

22
In the graph shown in figure 9 it can be seen that there is some additional benefit by enabling both queuing and
parallel query caching of the queries when viewing the average query response times. Bigger benefits can be
expected in more optimum conditions, where the database buffer cache size is much closer to the active data size
and where there is lower concurrency. Most production workloads will only actively access a small portion of the total
data in the database, and with increasing memory footprint of the systems it can lead to circumstances where a
substantial amount of the active data can reside in the database buffer cache for BI type workloads.
Figure 9. Average Query Response Time results of 200 mixed entry, intermediate and advanced queries by changing queuing and
caching parameters
Entry level queries shows minimal improvement with both queuing and caching enabled.
0
500
1000
1500
2000
2500
3000
Entry Intermediate Advanced
Response Time in Seconds
Query Type
Average Query Response Times
No queue/No cache
Queue/No cache
Queue/Cache