[Mondrian] Mondrian performance

Haridasan T haridasan.t at gmail.com
Sat Mar 3 10:56:30 EST 2007


Greetings,

I am also new to Mondrian.  Appreciate if your could let me know how to
connect to Oracle.  I copied the Oracle thin driver to apache/tomcat folder.
But unable to connect to Oracle database.  I am only able to run with access
database.

Which all XML files need to be changed
(server.xml and datasources.xml)

Please do mail me the syntax also

Thanks

Hari Nair


On 3/3/07, Pranav.Matekar at zycus.com <Pranav.Matekar at zycus.com> wrote:
>
>
> 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
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>


-- 
http://cfo-portal.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070303/b5860bd6/attachment.html 


More information about the Mondrian mailing list