I have degenereated dimension which is having 200,000 unique records. I am joining this with other 4 dimensions which has 50,100,50 rows respectively and next one is the time dimension is TIME which is at day granular level. When I run this in 8GB RAM, Intel i3 processor I am getting the response in 212707Msec. My end query is returning total of 3000 Rows as results. Time taken to execute is same even if I tried to re-open the same report second / third time. One thing I had observed is its not firing any new SQL's for the second /third time but getting the results from Cache I believe. My Questions are
a. Is Mondrian takes more time to read the results from cache?
b. Is there any parameter which can be adjusted to improve performance.