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