geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Hogstrom (JIRA)" <...@geronimo.apache.org>
Subject [jira] Created: (GERONIMO-2074) CMP Issues two selects for each CMP bean read operation
Date Fri, 02 Jun 2006 03:25:29 GMT
CMP Issues two selects for each CMP bean read operation
-------------------------------------------------------

         Key: GERONIMO-2074
         URL: http://issues.apache.org/jira/browse/GERONIMO-2074
     Project: Geronimo
        Type: Bug
    Security: public (Regular issues) 
    Reporter: Matt Hogstrom
 Assigned to: Gianny Damour 
     Fix For: 1.2


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