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
