[Mondrian] Mondrian performance

Julian Hyde julianhyde at speakeasy.net
Sat Mar 3 15:41:18 EST 2007


The query you are executing is a classic BAD query for mondrian. It
requires a lot of intermediate results -- the cartesian product of the
dimensions you are generating over -- in memory, so it will take a lot
of time and a lot of memory.
 
The iterator-based evaluation mechanism which Richard Emberson recently
introduced may help with some queries of this style, but that mechanism
is not fully mature yet.
 
Those kind of queries are well outside mondrian's sweet spot. I
recommend that you don't use mondrian for them.
 
Julian
 
 


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Pranav.Matekar at zycus.com
Sent: Saturday, March 03, 2007 12:18 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Mondrian performance



hi 

i am new to this group 
currently i am evaluating mondrian 

i have done some testing on mondrian 
with 6,000,000 records 

and 60,000 elements in one dimension 
and 6000 elements in others 10 dimensions 

i have used top in top, ie. top 10 supplier of top 10 categories (60,000
suppliers ),  via using generate and topcount 
it's taking more than 10 min 

and if i am applying filters on this query 
result is not coming 

i am currently testing via oracle 
i have created indexing on each column of star schema 
i have done analyze schema on oracle 

  
i used following setting 
mondrian.native.topcount.enable=true 
mondrian.rolap.CachePool.costLimit=2147483647 
mondrian.rolap.queryTimeout=600 

i checked logging of mondrian 
it's doing top in memory 
for 60,000 elements, if mondrian is doing top in memory and i am using
top in top for this dimension with filters 
getting result in 1 min is difficult. 

is there any solution for this problem? 

thank you. 


Pranav

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070303/a3e00822/attachment.html 


More information about the Mondrian mailing list