[Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation

Pedro Alves pedro at neraka.no-ip.org
Tue Jun 2 19:11:41 EDT 2009


if I have an agg here, will it be used?


pedro

On Tue, Jun 02, 2009 at 03:49:02PM -0700, Sherman Wood wrote:
> It is getting the values for the degenerate dimension. It should only get
> this once.
> 
> Sherman
> 
> -----Original Message-----
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> On Behalf Of Pedro Alves
> Sent: Wednesday, June 03, 2009 5:00 AM
> To: Mondrian Mailing List
> Subject: [Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation
> 
> 
> 
> Hello again.
> 
> 
> While implementing agg tables in my dashboards and trying to make this
> over 5 billion rows queries light speed, I stumbled upon a very weird
> thing
> 
> 
> Mondrian is doing the following query:
> 
>     2009-06-02 19:49:50,649 DEBUG [mondrian.rolap.RolapUtil]
>     SqlMemberSource.getMemberChildren: done executing sql [select 
>         "blocklist_requests_by_day"."gecko_version" as "c0"
>     from 
>         "blocklist_requests_by_day" as "blocklist_requests_by_day"
>     group by 
>         "blocklist_requests_by_day"."gecko_version"
>     order by 
>         "blocklist_requests_by_day"."gecko_version" ASC
>     ], exec+fetch 21993 ms, 425 rows
> 
> 
> This is a degenerated dimension, so it's kind'a expected; but the thing is
> that I'm not using this dimension in *any* query I'm doing.
> 
> 
> Any idea why mondrian is doing this?
> 
> 
> Thanks
> 
> 
> 
> -- 
> Pedro Alves
> pmgalves-at-gmail.com
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-- 
Pedro Alves
pmgalves-at-gmail.com




More information about the Mondrian mailing list