geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gianny Damour (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (GERONIMO-2074) CMP Issues two selects for each CMP bean read operation
Date Wed, 13 Dec 2006 11:26:24 GMT
     [ http://issues.apache.org/jira/browse/GERONIMO-2074?page=all ]

Gianny Damour resolved GERONIMO-2074.
-------------------------------------

    Resolution: Fixed
      Assignee: Matt Hogstrom  (was: Gianny Damour)

Fixed.

> CMP Issues two selects for each CMP bean read operation
> -------------------------------------------------------
>
>                 Key: GERONIMO-2074
>                 URL: http://issues.apache.org/jira/browse/GERONIMO-2074
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>            Reporter: Matt Hogstrom
>         Assigned To: Matt Hogstrom
>             Fix For: 1.2
>
>         Attachments: GERONIMO-2074.patch
>
>
> Number of executions               = 84422
>  Statement text                     = SELECT Q.symbol, Q.low, Q.open1, Q.volume, Q.price,
Q.high, Q.companyName, Q.change1 FROM QuoteEJB Q WHERE Q.symbol = ?
> Number of executions               = 84464
>  Statement text                     = SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol
= ?
> This is running the PrimitiveServlet2EntityLocal.  In this primitive a CMP Entity bean
is selected and all fields referenced.  Performance would be greatly improved if we only did
the full select and avoided the round trip of two queries.
> The difference in counts is beause of a bug I'm chasing with Jencks re: some Tx failing.

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