You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "Matt Hogstrom (JIRA)" <de...@geronimo.apache.org> on 2006/06/02 05:25:29 UTC
[jira] Created: (GERONIMO-2074) CMP Issues two selects for each CMP
bean read operation
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
[jira] Updated: (GERONIMO-2074) CMP Issues two selects for each CMP
bean read operation
Posted by "Gianny Damour (JIRA)" <de...@geronimo.apache.org>.
[ http://issues.apache.org/jira/browse/GERONIMO-2074?page=all ]
Gianny Damour updated GERONIMO-2074:
------------------------------------
Attachment: GERONIMO-2074.patch
I have just fixed two problems in TranQL related to prefetch group transformation of EJB-QL returning entities, e.g. SELECT OBJECT(o) FROM CMPEJB o, and caching of CMP entities across tx.
It is possible to have a single query for this primitive by defining a prefetching group for the the findByPrimaryKey finder and also addiing a inter tx cache for the QuoteEJB CMP, see attached plan.
> 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
[jira] Commented: (GERONIMO-2074) CMP Issues two selects for each
CMP bean read operation
Posted by "Matt Hogstrom (JIRA)" <de...@geronimo.apache.org>.
[ 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
[jira] Resolved: (GERONIMO-2074) CMP Issues two selects for each
CMP bean read operation
Posted by "Gianny Damour (JIRA)" <ji...@apache.org>.
[ 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
[jira] Commented: (GERONIMO-2074) CMP Issues two selects for each
CMP bean read operation
Posted by "Gianny Damour (JIRA)" <de...@geronimo.apache.org>.
[ 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