<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Too much time to download
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/vatoslokos83">Ophir Tahor</a> in <i>JBoss Portal</i> - <a href="http://community.jboss.org/message/586937#586937">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>We are using JBoss Portal version 2.6.5SP1 in our comopany. We didn't change the configuration of JBoss Portal that come with a default option of EHCache for the portal DB. I also checked the configuration of the hibernate and it seems correct which mean that the first\second levels are true and everything there seems fine.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The issue is that we have some gaps in our log files and we found out that the times spent on the Jboss Portal DB. The issue is that in every login we spend at least 300ms for it and also there are some places during the login that we spend the same amount of time on them (another 2-3 times).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>When I checked the Hibernate logs I found out those line (this is from the first login, and those are just samples from 2000 lines):</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.SQL] select displaynam0_.INSTANCE_PK as INSTANCE1_0_, displaynam0_.TEXT as TEXT0_, displaynam0_.LOCALE as LOCALE0_ from JBP_PORTAL_OBJECT_DNAMES displaynam0_ where displaynam0_.INSTANCE_PK=?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.cache.EhCache]: key: org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates#119 \\this line showen many times with diff keys</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.loader.Loader]: [user:] [context:] result row: EntityKey[org.jboss.portal.core.impl.model.portal.PortalObjectImpl#95] \\this line showen many times with diff rows</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>and finally I see those 2 lines at the end:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.engine.StatefulPersistenceContext]: initializing non-lazy collections</p><p>[org.hibernate.loader.Loader]:  done loading collection</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I understand that at those times we are loading things from the DB but: a. Why this is happenned every time instead of using EHCache. b. how I can avoid it or minimize the times that spend.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>* I uploaded the full log file in case that you want to see everything</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks for any response!</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/586937#586937">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss Portal at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2011">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>