to increase the query performance instead of using precalculated web templet we were suggested to use BLOB(Binary Large Objects)transparent CACHE.
can you please help me out by giving information about BLOB CACHE.
like what are the advantages and disadvatages over precalculated templets and the settings.
i gone through few documents and forums and once such information on this is
"Best Practice store CACHE in BLOB table/cluster table/flat file so that ALL Application servers can UTILIZE it.
In these way USER running query from ALL/ANY Aplication server will be directly UTILIZING CACHE and faster the performance.
In these way you are not disturbing any SETTINGS . "
my question is
in cache parameters we have the option of changing the persistant mode to Transparant table (BLOB). in addition to this change do we need to change anything in cache mode in RSRT(what we have here is main memory without swaping).
how do u know that my query is getting data from cache memory or from cube(any transaction code.
and if i change the persistant mode to Transparant table (BLOB) then when the query runs will all the application servers (if we have different application servers) pick up result from these tables. if so do we have to make any settings??
help require guys
thanks in advance