[Mondrian] mondrian.rolap.aggregates.ChooseByVolume Property inMondrian

Julian Hyde julianhyde at speakeasy.net
Wed Apr 18 03:55:51 EDT 2007


No one ever studied it, to my knowledge. This is one of those cases
where the developer (in this case Richard Emberson) gives the end-user a
choice because he doesn't know the answer.
 
My gut would be to go with row count, because it is simpler.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of JIE WU
Sent: Tuesday, April 17, 2007 9:13 PM
To: mondrian at pentaho.org
Subject: [Mondrian] mondrian.rolap.aggregates.ChooseByVolume Property
inMondrian



Hi, 

 

As suggested in the Mondrian spec,
mondrian.rolap.aggregates.ChooseByVolume determines whether to choose
aggregate tables based on volumn or rows. My question is that is there
any study on this property to tell which method (ByVolumn or ByRows) to
choose aggTables is better under which circumstances? If so, has
Mondrian been evaluated against this property? What is the result like?
This information would be quite useful when coming to tuning Mondrian
for selecting aggregate tables?

 

Can anybody shed some light on this? I would be greatly appreciative if
you could help.

 

Thanks

Jie

 

===================

Jie Wu

FIT 410, The University Of Memphis

Memphis, TN, 38111, USA

www.jiewu.info

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


More information about the Mondrian mailing list