[Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation
Sherman Wood
swood at jaspersoft.com
Tue Jun 2 19:17:17 EDT 2009
Once per schema/DB connection, unless as you say, it is aged out of the
JVM.
Sherman
-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Peter Tran
Sent: Wednesday, June 03, 2009 9:05 AM
To: Mondrian developer mailing list
Subject: RE: [Mondrian] Heavy SqlMemberSource.getMemberChildren evaluation
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
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
More information about the Mondrian
mailing list