openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-168) sql optimize n rows query hint
Date Tue, 27 Mar 2007 02:51:32 GMT

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

Patrick Linskey commented on OPENJPA-168:
-----------------------------------------

> 2. I don't think we need a FetchConfiguration instance variable. 

My understanding is that you can often provide hints about how many results might be returned,
as well as whether one or many results will be loaded. So it seems like we might want to expose
some way for the user to specify for an arbitrary query (or relation load) that they expect
n records to be returned.

> 4. "getOptimizeClause" seems too generic.

Agreed. The optimizations tend to get tucked into different parts of the SQL statement; this
probably will end up needing to be significantly different for different db back-ends.

> 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
>         Attachments: OPENJPA-168.patch.txt, OPENJPA-168.patch2.txt
>
>
> 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