[Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation

Peter Tran ptran at prospricing.com
Tue Jun 2 19:05:11 EDT 2009


Sherman,

It would do this per Mondrian instance right?  If you have several JVMs with Mondrian running in each, it would do this once per Mondrian JVM.

It's not necessarily cache, but even if it was it may get aged out depending on the memory allocated for the JVM.

-Peter

-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Sherman Wood
Sent: Tuesday, June 02, 2009 5:49 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation

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




More information about the Mondrian mailing list