query performance when rebuilding OLAP cache -
11-02-2006
, 08:17 AM
Hi all,
I have a MOLAP cube with five measures group and my goal is process all
measures (with XMLA script) every five minutes. I don't want to use the
Proactive Caching. I don't believe that the service works fine. So,
when I execute the xmla script, the query performance are good, but
when the rebuilding cache is started, the query performance are very
slow.
I think that when rebuild cache is running, the query would have to be
executed on the old cache.
All Suggestions are appreciate!
CristianM |