geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Hogstrom <m...@hogstrom.org>
Subject Results of testing Gianny's TranQL Performance Improvements for CMP entity beans
Date Mon, 05 Jun 2006 03:53:56 GMT
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 = ?

Matt

Mime
View raw message