[ http://issues.apache.org/jira/browse/GERONIMO-2074?page=comments#action_12414638 ]
Gianny Damour commented on GERONIMO-2074: ----------------------------------------- Matt, could you please confirm that it indeed increases the performance? > 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 > Assignee: Gianny Damour > 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