<!doctype HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">











<html>
<head>
    
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>OFBiz: Core Web Tools: Entity Performance Test</title>
    <script language='javascript' src='/images/calendar1.js' type='text/javascript'></script>
    <link rel='stylesheet' href='/images/maincss.css' type='text/css'>
    <link rel='stylesheet' href='/images/tabstyles.css' type='text/css'>    
</head>
<body>
<TABLE border=0 width='100%' cellspacing='0' cellpadding='0' class='headerboxoutside'>
  <TR>
    <TD width='100%'>
      <table width='100%' border='0' cellspacing='0' cellpadding='0' class='headerboxtop'>
        <tr>
          
            <TD align=left width='1%'><IMG alt="OFBiz: Core Web Tools" src='/images/ofbiz_logo.jpg'></TD>
                   
          <TD align=right width='1%' nowrap >
              
                <div class="insideHeaderText">Welcome&nbsp;THE&nbsp;ADMINISTRATOR!</div>
              
              
            <div class="insideHeaderText">&nbsp;2004-03-05 12:55:41.45</div>
          </td>
        </tr>
      </table>
    </TD>
  </TR>
</TABLE>













<table align="center" width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr bgcolor="#FFFFFF">
    <td height="15">
          <table width="100%" border="0" cellspacing="0" cellpadding="0">                      
        <tr>               
                                                                     
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/partymgr/control/main?externalLoginKey=EL600593321176" title="Party Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/partymgr/control/main?externalLoginKey=EL600593321176" title="Party Manager" class="tablink">Party</a></td>
                <td class="tabdownright"><a href="/partymgr/control/main?externalLoginKey=EL600593321176" title="Party Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr> 
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>                           
            </table>
          </td>         
          
                
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/marketing/control/main?externalLoginKey=EL600593321176" title="Marketing Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/marketing/control/main?externalLoginKey=EL600593321176" title="Marketing Manager" class="tablink">Marketing</a></td>
                <td class="tabdownright"><a href="/marketing/control/main?externalLoginKey=EL600593321176" title="Marketing Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>
          
                                                    
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/catalog/control/main?externalLoginKey=EL600593321176" title="Catalog Manager" class="tablinkselected"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/catalog/control/main?externalLoginKey=EL600593321176" title="Catalog Manager" class="tablink">Catalog</a></td>
                <td class="tabdownright"><a href="/catalog/control/main?externalLoginKey=EL600593321176" title="Catalog Manager" class="tablinkselected"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>  
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>                                           
            </table>
          </td>             
          
          
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/facility/control/main?externalLoginKey=EL600593321176" title="Facility Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/facility/control/main?externalLoginKey=EL600593321176" title="Facility Manager" class="tablink">Facility</a></td>
                <td class="tabdownright"><a href="/facility/control/main?externalLoginKey=EL600593321176" title="Facility Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>                
          
                                 
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/ordermgr/control/main?externalLoginKey=EL600593321176" title="Order Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/ordermgr/control/main?externalLoginKey=EL600593321176" title="Order Manager" class="tablink">Order</a></td>
                <td class="tabdownright"><a href="/ordermgr/control/main?externalLoginKey=EL600593321176" title="Order Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>
          
          
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/accounting/control/main?externalLoginKey=EL600593321176" title="Accounting" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/accounting/control/main?externalLoginKey=EL600593321176" title="Accounting" class="tablink">Accounting</a></td>
                <td class="tabdownright"><a href="/accounting/control/main?externalLoginKey=EL600593321176" title="Accounting" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>     
                         
          
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/workeffort/control/main?externalLoginKey=EL600593321176" title="WorkEffort" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/workeffort/control/main?externalLoginKey=EL600593321176" title="WorkEffort" class="tablink">WorkEffort</a></td>
                <td class="tabdownright"><a href="/workeffort/control/main?externalLoginKey=EL600593321176" title="WorkEffort" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>                        
          
          
          <td height="15" class="tabdownblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabdownleft"><a href="/content/control/main?externalLoginKey=EL600593321176" title="Content Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabdowncenter"><a href="/content/control/main?externalLoginKey=EL600593321176" title="Content Manager" class="tablink">Content</a></td>
                <td class="tabdownright"><a href="/content/control/main?externalLoginKey=EL600593321176" title="Content Manager" class="tablink"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>
              <tr><td colspan="3" class="blackarea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>
              <tr><td colspan="3" class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td></tr>               
            </table>
          </td>  
                    
          <td height="15" class="mainblock">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="tabupleft"><a href="/webtools/control/main?externalLoginKey=EL600593321176" title="WebTools" class="tablinkselected"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
                <td nowrap="nowrap" class="tabupcenter"><a href="/webtools/control/main?externalLoginKey=EL600593321176" title="WebTools" class="tablinkselected">WebTools</a></td>
                <td class="tabupright"><a href="/webtools/control/main?externalLoginKey=EL600593321176" title="WebTools" class="tablinkselected"><img src="/images/spacer.gif" alt="" width="10" height="15" border="0"></a></td>
              </tr>                        
            </table>
          </td>            
          <td width="100%" style="vertical-align: bottom;">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                
              <tr>
                <td class="whitearea"><img src="/images/spacer.gif" alt="" height="1"></td>               
              </tr>               
            </table>
          </td>           
        </tr>        
      </table>
    </td>
  </tr>
</table>



<div class="centerarea">
  







<div class="apptitle">&nbsp;Core Application WebTools&nbsp;</div>
<div class="row">
  <div class="col"><a href="/webtools/control/main" class="headerButtonLeft">Main</a></div>     
  
  
    <div class="col-right"><a href="/webtools/control/logout" class="headerButtonRight">Logout</a></div>
    
  <div class="col-fill">&nbsp;</div>
</div>
        

  <div class="contentarea">
    <div style='border: 0; margin: 0; padding: 0; width: 100%;'>
      <table style='border: 0; margin: 0; padding: 0; width: 100%;' cellpadding='0' cellspacing='0'>
        <tr>
          
          <td width='100%' valign='top' align='left'>
            

             









<div class="head1">Entity Engine Performance Tests</div>

<div class="tabletext">NOTE: These performance results may vary a great deal for different
databases, JDBC drivers, JTA implementations (transaction managers), connection pools, 
local vs. remote deployment configurations, and hardware (app server hardware, database 
server hardware, network connections).</div>

<br>



<table width="100%" border="1" cellspacing="0" cellpadding="2">
  <tr>
    <td><div class="tabletext"><b>Operation</b></div></td>
    <td><div class="tabletext"><b>Entity</b></div></td>
    <td><div class="tabletext"><b>Calls</b></div></td>
    <td><div class="tabletext"><b>Seconds</b></div></td>
    <td><div class="tabletext"><b>Seconds/Call</b></div></td>
    <td><div class="tabletext"><b>Calls/Second</b></div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">findByPrimaryKey</div></td>
    <td><div class="tabletext">Large:Product</div></td>
    <td><div class="tabletext">1000</div></td>
    <td><div class="tabletext">4.817</div></td>
    <td><div class="tabletext">0.004817</div></td>
    <td><div class="tabletext">207.5980900975711</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">findByPrimaryKeyCache</div></td>
    <td><div class="tabletext">Large:Product</div></td>
    <td><div class="tabletext">10000</div></td>
    <td><div class="tabletext">0.171</div></td>
    <td><div class="tabletext">1.7100000000000002E-5</div></td>
    <td><div class="tabletext">58479.53216374268</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">findByPrimaryKey</div></td>
    <td><div class="tabletext">Small:Party</div></td>
    <td><div class="tabletext">1000</div></td>
    <td><div class="tabletext">1.989</div></td>
    <td><div class="tabletext">0.001989</div></td>
    <td><div class="tabletext">502.76520864756156</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">findByPrimaryKeyCache</div></td>
    <td><div class="tabletext">Small:Party</div></td>
    <td><div class="tabletext">10000</div></td>
    <td><div class="tabletext">0.115</div></td>
    <td><div class="tabletext">1.15E-5</div></td>
    <td><div class="tabletext">86956.52173913043</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">create</div></td>
    <td><div class="tabletext">Large:Product</div></td>
    <td><div class="tabletext">1000</div></td>
    <td><div class="tabletext">5.49</div></td>
    <td><div class="tabletext">0.00549</div></td>
    <td><div class="tabletext">182.14936247723134</div></td>
  </tr>  
  
  <tr>
    <td><div class="tabletext">update</div></td>
    <td><div class="tabletext">Large:Product</div></td>
    <td><div class="tabletext">1000</div></td>
    <td><div class="tabletext">3.645</div></td>
    <td><div class="tabletext">0.003645</div></td>
    <td><div class="tabletext">274.34842249657066</div></td>
  </tr>    
  
  <tr>
    <td><div class="tabletext">remove</div></td>
    <td><div class="tabletext">Large:Product</div></td>
    <td><div class="tabletext">1000</div></td>
    <td><div class="tabletext">8.632</div></td>
    <td><div class="tabletext">0.008632</div></td>
    <td><div class="tabletext">115.84800741427247</div></td>
  </tr>      
  
  <tr>
    <td><div class="tabletext">new HashMap</div></td>
    <td><div class="tabletext">N/A</div></td>
    <td><div class="tabletext">100000</div></td>
    <td><div class="tabletext">0.084</div></td>
    <td><div class="tabletext">8.400000000000001E-7</div></td>
    <td><div class="tabletext">1190476.1904761903</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">UtilMisc.toMap</div></td>
    <td><div class="tabletext">N/A</div></td>
    <td><div class="tabletext">100000</div></td>
    <td><div class="tabletext">0.021</div></td>
    <td><div class="tabletext">2.1000000000000003E-7</div></td>
    <td><div class="tabletext">4761904.761904761</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">UtilCache.get(String) - basic settings</div></td>
    <td><div class="tabletext">N/A</div></td>
    <td><div class="tabletext">1000000</div></td>
    <td><div class="tabletext">0.099</div></td>
    <td><div class="tabletext">9.9E-8</div></td>
    <td><div class="tabletext">1.01010101010101E7</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">UtilCache.get(GenericPK) - basic settings</div></td>
    <td><div class="tabletext">N/A</div></td>
    <td><div class="tabletext">1000000</div></td>
    <td><div class="tabletext">0.452</div></td>
    <td><div class="tabletext">4.52E-7</div></td>
    <td><div class="tabletext">2212389.3805309734</div></td>
  </tr>
  
  <tr>
    <td><div class="tabletext">UtilCache.put(GenericPK) - basic settings</div></td>
    <td><div class="tabletext">N/A</div></td>
    <td><div class="tabletext">1000000</div></td>
    <td><div class="tabletext">0.453</div></td>
    <td><div class="tabletext">4.53E-7</div></td>
    <td><div class="tabletext">2207505.518763797</div></td>
  </tr>
</table>


          </td>
          
        </tr>
      </table>       
    </div>
    <div class='spacer'></div>
  </div>
</div>

<br>
<table width="100%" border="0" cellpadding="10" cellspacing="0">
  <tr>
    <td class="smallSubmit">For CellularOne internal use only. </td>
  </tr>
</table>


</body>
</html>