[
https://issues.apache.org/jira/browse/TRAFODION-27?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14623188#comment-14623188
]
ASF GitHub Bot commented on TRAFODION-27:
-----------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/25
Fix for [TRAFODION-27] - Time consuming compilation for
queries of BLOB with JOINs
A new CQD EXE_MEMORY_FOR_PROBE_CACHE_IN_MB is introduced
to limit the amount of memory consumed in probe cache
operator. The default value is 100MB.
For other details, refer to JIRA
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-27
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/25.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #25
----
commit ac80fbdbfb8a459b75b23fa992512f62370c03f2
Author: Selva Govindarajan <[email protected]>
Date: 2015-07-11T01:56:42Z
Fix for [TRAFODION-27] - Time consuming compilation for
queries of BLOB with JOINs
A new CQD EXE_MEMORY_FOR_PROBE_CACHE_IN_MB is introduced
to limit the amount of memory consumed in probe cache
operator. The default value is 100MB.
For other details, refer to JIRA
----
> Time consuming compilation for queries of BLOB with JOINs
> ----------------------------------------------------------
>
> Key: TRAFODION-27
> URL: https://issues.apache.org/jira/browse/TRAFODION-27
> Project: Apache Trafodion
> Issue Type: Bug
> Environment: Trafodion 1.2, HDP 2.2, CentOS 6
> Reporter: Haifeng Li
> Priority: Minor
> Attachments: trafodion27_qry.sql, trafodion27_setup.sql
>
>
> It takes 3 ~ 5 seconds to compile a query that returns a BLOB field by
> joining two tables. If a query is cached and subsequent queries are 'similar'
> to
> the initial query, those subsequence compilation times will usually be
> much faster. However, sometimes we observe that subsequent queries with
> literal difference still take long time in sqlci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
