[Mondrian] Mondrian and pgpool

Julian Hyde jhyde at pentaho.com
Tue Aug 17 16:11:45 EDT 2010


Mondrian sends all queries using mondrian.rolap.RolapUtil.executeQuery. This
creates a mondrian.rolap.SqlStatement, then calls SqlStatement.execute. As
you can see, it gets a connection from the data source (which is probably a
connection pool), calls either Connection.createStatement() or
Connection.createStatement(int, int), then calls
Statement.executeQuery(String). None of this is particularly unusual, except
perhaps the (int, int) version of createStatement.
 
I don't think you'll get much advantage from query result caching. Mondrian
caches the results of queries, and as a result doesn't tend to issue the
same query twice.
 
Query parallelization may be useful.
 
I can't help you any further than this. I would suggest running mondrian in
a debugger so that you can see the lifecycle and also look at field values
in pgpool connections and statements.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of John Carvajal
Sent: Tuesday, August 10, 2010 11:32 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] Mondrian and pgpool



Any idea ?

 

De: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] En
nombre de John Carvajal
Enviado el: viernes, 23 de julio de 2010 07:27 a.m.
Para: mondrian at pentaho.org
Asunto: [Mondrian] Mondrian and pgpool

 

I've been working on an idea, our idea is to work with pgpool-II to improve
the performance of some data access, basically what we need is to use the
query_cache and the option to parallelize the querys. 

The idea sounds interesting to us because we may take full advantage of the
current ROLAP and management about how to access the data.

we install the pgpool and works well (there is a bug in the query_cache
already correct with the help of a post), then we test from the interface
and makes the cache without difficulty, but when I tried to work with
Mondrian query_cache simply does not work.

The theory that I have (supported some debug to pgpool) is when mondrian
send the SQL statement, it would seem that is sent in a special way, maybe
this comes in a transaction or an execute, but it makes the pgpool
identified as a different query and process it differently and do not save
the cache.

if anyone has any idea about it or can guide us to see if we can configure
the JDBC driver in some way to stop this from happening or if we need to do
some additional configuration, please let us know.

Thanks 

 

 

John Carvajal Arciniegas

Gerente Innovacion y Desarrollo

Grupo Empresarial BIT

PBX: (57 2) 485 46 61 

jcarvajal at grupobit.net <mailto:aecheverry at grupobit.net> 

www.grupobit.net

 

 

 

  _____  

"Este mensaje es confidencial, puede contener información privilegiada y no
puede ser usado ni divulgado por personas distintas de su destinatario. Si
obtiene esta transmisión por error, por favor destruya su contenido y avise
al remitente. Está prohibida su retención, grabación, utilización o
divulgación con cualquier propósito.

Este mensaje ha sido sometido a programas antivirus. No obstante, PARQUESOFT
no asume ninguna responsabilidad por eventuales da&nacute;os generados por
el recibo y uso de este material, siendo responsabilidad del destinatario
verificar con sus propios medios la existencia de virus u otros defectos.

 

  _____  

This message is confidential and may contain privileged information, it may
not be used or disclosed by any person other than the individual to whom it
is addressed. If obtained in error, please destroy the information received
and contact the sender. Its retention, recording, use or distribution with
any intention are prohibited.

This message has been tested by antivirus software. Nonetheless, PARQUESOFT
assumes no responsibility for damages caused by the receipt or use of the
material, given that it is the responsibility of the addressee to verify by
his own means the presence of a virus or any other harmful defect."


  _____  

"Este mensaje es confidencial, puede contener información privilegiada y no
puede ser usado ni divulgado por personas distintas de su destinatario. Si
obtiene esta transmisión por error, por favor destruya su contenido y avise
al remitente. Está prohibida su retención, grabación, utilización o
divulgación con cualquier propósito.

Este mensaje ha sido sometido a programas antivirus. No obstante, PARQUESOFT
no asume ninguna responsabilidad por eventuales da&nacute;os generados por
el recibo y uso de este material, siendo responsabilidad del destinatario
verificar con sus propios medios la existencia de virus u otros defectos.


  _____  

This message is confidential and may contain privileged information, it may
not be used or disclosed by any person other than the individual to whom it
is addressed. If obtained in error, please destroy the information received
and contact the sender. Its retention, recording, use or distribution with
any intention are prohibited.

This message has been tested by antivirus software. Nonetheless, PARQUESOFT
assumes no responsibility for damages caused by the receipt or use of the
material, given that it is the responsibility of the addressee to verify by
his own means the presence of a virus or any other harmful defect."

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100817/2821fcc3/attachment.html 


More information about the Mondrian mailing list