[Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation

[Pedro Alves]

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