[Mondrian] Mondrian performance
Julian Hyde
julianhyde at speakeasy.net
Sat Mar 3 15:41:18 EST 2007
The query you are executing is a classic BAD query for mondrian. It
requires a lot of intermediate results -- the cartesian product of the
dimensions you are generating over -- in memory, so it will take a lot
of time and a lot of memory.
The iterator-based evaluation mechanism which Richard Emberson recently
introduced may help with some queries of this style, but that mechanism
is not fully mature yet.
Those kind of queries are well outside mondrian's sweet spot. I
recommend that you don't use mondrian for them.
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Pranav.Matekar at zycus.com
Sent: Saturday, March 03, 2007 12:18 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Mondrian performance
hi
i am new to this group
currently i am evaluating mondrian
i have done some testing on mondrian
with 6,000,000 records
and 60,000 elements in one dimension
and 6000 elements in others 10 dimensions
i have used top in top, ie. top 10 supplier of top 10 categories (60,000
suppliers ), via using generate and topcount
it's taking more than 10 min
and if i am applying filters on this query
result is not coming
i am currently testing via oracle
i have created indexing on each column of star schema
i have done analyze schema on oracle
i used following setting
mondrian.native.topcount.enable=true
mondrian.rolap.CachePool.costLimit=2147483647
mondrian.rolap.queryTimeout=600
i checked logging of mondrian
it's doing top in memory
for 60,000 elements, if mondrian is doing top in memory and i am using
top in top for this dimension with filters
getting result in 1 min is difficult.
is there any solution for this problem?
thank you.
Pranav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070303/a3e00822/attachment.html
More information about the Mondrian
mailing list