geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gianny Damour (JIRA)" <...@geronimo.apache.org>
Subject [jira] Closed: (GERONIMO-985) CMP FBPK Yields an individual SELECT per column
Date Tue, 20 Sep 2005 11:03:28 GMT
     [ http://issues.apache.org/jira/browse/GERONIMO-985?page=all ]
     
Gianny Damour closed GERONIMO-985:
----------------------------------

    Fix Version: 1.0-M5
     Resolution: Fixed
      Assign To: Gianny Damour

By default, i.e. when no prefetching group is specified for a given CMP,  all the CMP fields
mapped to non LOB columns are now faulted in memory.

> CMP FBPK Yields an individual SELECT per column
> -----------------------------------------------
>
>          Key: GERONIMO-985
>          URL: http://issues.apache.org/jira/browse/GERONIMO-985
>      Project: Geronimo
>         Type: Bug
>     Versions: 1.0-M5
>  Environment: Geronimo w/Derby
>     Reporter: Matt Hogstrom
>     Assignee: Gianny Damour
>      Fix For: 1.0-M5

>
> I'm testing the DayTrader Application and it appears that FBPK finds are executing a
single SELECT per field in the CMP field.  Here are the SELECTs making up a single OrderEJB.findByPrimaryKey().
 This should be broken down into a single SELECT for the entity.
> SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.companyName FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.volume FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.price FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.open1 FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.low FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.high FROM QuoteEJB Q WHERE Q.symbol = s:153
> SELECT Q.change1 FROM QuoteEJB Q WHERE Q.symbol = s:153

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message