You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/07/14 09:43:05 UTC

[jira] [Assigned] (TRAFODION-27) Time consuming compilation for queries of BLOB with JOINs

     [ https://issues.apache.org/jira/browse/TRAFODION-27?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah reassigned TRAFODION-27:
---------------------------------------

    Assignee: Selvaganesan Govindarajan

> 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
>            Assignee: Selvaganesan Govindarajan
>            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)