[Mondrian] Mondrian and pgpool

John Carvajal jcarvajal at parquesoft.com
Fri Jul 23 08:27:19 EDT 2010

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.




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> 





"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ñ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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100723/5b6220cc/attachment.html 

More information about the Mondrian mailing list