Dear Mondrian Developer,<br><br>I have a slight problem. I am trying optimize Mondrian's performance via the use of aggregate tables. The volume of data we have is pretty large. After enabling the use of aggregate table with about 25 or so aggregate tables, the system comes to halt and crashes due to "out of memory". I gave it 2 GB of ram (that's all i have to work with for now). When not using the aggregate table it works fine, slow but it works and uses at most half of it's maximum memory. I was wondering if you guys could shed some light on how it is Mondrian caching aggregate tables. I would also appreciate any other helpful tips on aggregate/performance tuning. <br>
<br>P.S. Currently we have about 3GB database but it's not even .1% of what we'll have.<br><br><br><br>Thanks, <font size="4"><span style="background-color:rgb(255,255,255);color:rgb(51,102,255);font-family:comic sans ms,sans-serif"><span style="color:rgb(0,0,0)"><br>
<br></span>Monir Hossain</span></font><br>Software Engineering, Rochester Institute of Technology