[ 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