openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ritika Maheshwari (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-168) sql optimize n rows query hint
Date Wed, 14 Mar 2007 17:02:12 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480839
] 

Ritika Maheshwari commented on OPENJPA-168:
-------------------------------------------

Abe is there a way from selectImpl to know if this is the top select or not.For example if
EagerFetchMode set to parallel if we are trying to retrieve Department and department is eagerly
fetching Emps.Then a single user query (select d from Department d) will produce multiple
push down sqls.Now if the user set the hint to optimize on the top level query ie select d
from Department d then it should appear only on the top level query and not the subsequent
queries.But to do so we need the ability to be able to distinguish if this is the top select
or not.Is there currently any mechanism to do this

ritika

> sql optimize n rows query hint
> ------------------------------
>
>                 Key: OPENJPA-168
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-168
>             Project: OpenJPA
>          Issue Type: New Feature
>            Reporter: David Wisneski
>         Assigned To: David Wisneski
>
> There werre various comments from Patrick, Abe and Kevin Sutter about the code that I
checked related to Optimize hint.  So I have gone back and relooked at this and wil be making
some changes.  At Kevin's suggestion I will do this through a JIRA feature so that folks will
have opportunity to comment on this before the code is actually done and checked in.

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