openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-1493) Performance improvement in SelectImpl.getTableIndex() for JPQL without subselect
Date Wed, 03 Feb 2010 04:53:18 GMT

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

Catalina Wei updated OPENJPA-1493:
----------------------------------

          Description: 
OPENJPA-1185 introduced query context for table alias resolution that improved JPQL subquery
processing.
However, JPQL queries without subselect pay  performance penalty because of the alias resolution
by query context. In fact, if JPQL or QueryExpression do not contain subselect, then the table
alias resolution can be simplified.
This can be done by checking if a SelectImpl is involved in a subquery:
If SelectImpl is not a subquery (it has no parent) or SelectImpl does not have any subselects,
then the alias resolution by query context can be by-passed.

  was:
OPENJPA-1185 introduced query context that fixes JPQL subquery problems.
JPQL queries without subselect pay some performance penalty because of the alias resolution
by query context
This can be avoided with a simple test which checks to see if the SelectImpl is involved in
a subquery.
If SelectImpl is not a subquery (it has a parent) or SelectImpl does not have any subselects,
then the alias resolution 
by query context can be by-passed.

    Affects Version/s: 2.1.0
                       2.0.1
                       2.0.0

> Performance improvement in SelectImpl.getTableIndex() for JPQL without subselect
> --------------------------------------------------------------------------------
>
>                 Key: OPENJPA-1493
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1493
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: query
>    Affects Versions: 2.0.0, 2.0.1, 2.1.0
>            Reporter: Catalina Wei
>            Assignee: Catalina Wei
>
> OPENJPA-1185 introduced query context for table alias resolution that improved JPQL subquery
processing.
> However, JPQL queries without subselect pay  performance penalty because of the alias
resolution by query context. In fact, if JPQL or QueryExpression do not contain subselect,
then the table alias resolution can be simplified.
> This can be done by checking if a SelectImpl is involved in a subquery:
> If SelectImpl is not a subquery (it has no parent) or SelectImpl does not have any subselects,
then the alias resolution by query context can be by-passed.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message