[ http://issues.apache.org/jira/browse/GERONIMO-2074?page=comments#action_12414685 ]
Matt Hogstrom commented on GERONIMO-2074: ----------------------------------------- Gianny, I applied your changes to fix the double execution. It looks like the modifications you made overall improved performance by about 10% (from 1445 to 1591). However, I still see the double execution of the SQL for the Quote bean. So we can still eek out some extra performance. The best number on the servers I tested has been about 2000 so we're almost there :) Here are the stats from the testing I did tonight. *Before TranQL Change:* 06/04/2006 22:02:25 IWL0060I Page throughput = *1445.272 /s* This data is already in the JIRA. *With TranQL Changes:* 06/04/2006 22:50:45 IWL0060I Page throughput = *1591.233 /s* Number of executions = 123809 Number of compilations = 1 Total execution time (sec.ms) = 7.302716 Total user cpu time (sec.ms) = 5.687500 Total system cpu time (sec.ms) = 0.859375 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 = 123809 Number of compilations = 1 Total execution time (sec.ms) = 6.219300 Total user cpu time (sec.ms) = 4.765625 Total system cpu time (sec.ms) = 0.296875 Statement text = SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = ? *With TranQL CMP Caching Option:* 06/04/2006 23:01:09 IWL0060I Page throughput = *1988.110* /s These are the queries that are being executed while caching is enabled. Note the difference between the queries. I'm not sure why this is. Number of executions = 973 Number of compilations = 1 Total execution time (sec.ms) = 0.052875 Total user cpu time (sec.ms) = 0.015625 Total system cpu time (sec.ms) = 0.015625 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 = 221945 Number of compilations = 1 Total execution time (sec.ms) = 12.888160 Total user cpu time (sec.ms) = 9.843750 Total system cpu time (sec.ms) = 1.515625 Statement text = SELECT Q.symbol, Q.symbol, Q.low, Q.open1, Q.volume, Q.price, Q.high, Q.companyName, Q.change1 FROM QuoteEJB Q WHERE Q.symbol = ? > 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
