Interview Questions   Tutorials   Discussions   Programs   Videos   

OBIEE - What are the different types of caching?

asked ramk September 18, 2013 01:55 PM  

What are the different types of caching?


2 Answers

answered By   0  
There are two types of cache
record set cache - where data is chached
request cache - where the answer or analysis query is cached
   add comment

answered By SRVMTrainings   0  
The cache management can be done in three different ways: 1.Cache disabled: The NQConfig.INI file has the ENABLE parameter that can be set to NO. This disables the cache for the server. After the change the server needs a restart. The disable cache will prevent any queries to use/update cache. This may lead to slower performances, but will be useful in the case of lesser accesses that are being expected. Enabling of the cache will not be concerned about the cache updates and synchronization. 2.Caching set for each physical table: The admin tool has the option ?Make cache-abble? for the tables. You can click that and go into the general settings. This has the cache persistence in the option. This will make the queries to and fro from the physical table to use the cache. This can also be set according to specific time interval. This will help you in getting a good interactive response on the view layer. Any table that is frequently updated can have this setting on for reasonable amount of time. 3.Event Polling data: The event polling data table keeps track of the different updates that are done on the different tables. The application is going to updated this event polling table for each query of update into the physical table. This stand-alone table can get the required frequency statistics for each table to maintain the cache policies as required.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  Question tags

obiee × 1

Asked 5 years and 11 months ago ago
Number of Views -902
Number of Answers -2
Last updated
4 years and 2 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!