[ 
https://issues.apache.org/jira/browse/KYLIN-2001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15509858#comment-15509858
 ] 

Tajdar Siddiqui commented on KYLIN-2001:
----------------------------------------

This is how I got it working locally.

Essentially 2 parts of the change :

1.Use a Poolable DataSource (org.apache.commons.dbcp.BasicDataSource) instead 
of  DriverManagerDataSource in org.apache.kylin.rest.service.CacheService

Set poolPreparedStatements to TRUE on the dataSource.

2.The OlapContext (org.apache.kylin.query.relnode.OLAPContext) needs to treated 
in parity with cached PreparedStatement. This part of the change is not very 
elegant and I am cleaning it up.

Thanx,



> PreparedStatement Caching Support
> ---------------------------------
>
>                 Key: KYLIN-2001
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2001
>             Project: Kylin
>          Issue Type: Improvement
>    Affects Versions: v1.5.2
>            Reporter: Tajdar Siddiqui
>            Assignee: Billy(Yiming) Liu
>
> Please refer to :
> Discussion on "Bindable cache" on calcite-dev mailing list (Aug 2016)
> and
> http://apache-kylin.74782.x6.nabble.com/PreparedStatement-caching-in-kylin-td5618.html
> Ability to reuse prepared statements gives a very significant performance 
> boost.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to