geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Hogstrom (JIRA)" <...@geronimo.apache.org>
Subject [jira] Commented: (GERONIMO-2074) CMP Issues two selects for each CMP bean read operation
Date Mon, 05 Jun 2006 03:54:30 GMT
    [ 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


Mime
View raw message