<div dir="ltr"><div><div><div>Hi,<br></div>What you do is the only way to handle the increase of the jcr repository.<br></div><div>Do you use a external db (oracle, postgres, etc..) or the build in db in Guvnor ? I noticed many times that the default embedded takes a huge disk place. I am often using postgres as a persistent db for jackrabbit and the size is reasonable.<br>
</div>Just a note about Mark's remark on jcr, versus Git. Git contains history also and the items that are stored from the Drools workbench <br>are quit big also (XML file with hundreds of line modified per version in decision tables, etc..)., Just to say that it can become bigger also :)<br>
</div><div>And furthermore with guvnor/jackrabbit accessing element by status/categories is super fast because it is optimized in jcr jackrabbit. <br>Optimization is like index in relational databases, it takes disk place.<br>
</div><div>Cheers<br></div><div>Nicolas Héron<br></div><div><br><br></div><div> <br></div><div> <br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-02-09 16:39 GMT+01:00 Mark Proctor [via Drools] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=4028027&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span>:<br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">
There is no easy way to deal with this in 5.5, other than importing and exporting. The problem no longer exists in 6.x, as we now use GIT.<div><br></div></div><div>Mark<br><div><div><div class="h5"><div>On 9 Feb 2014, at 15:30, Demian Calcaprina <<a href="http://user/SendEmail.jtp?type=node&node=4028026&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:</div>
<br></div></div><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="border-left:2px solid #cccccc;padding:0 1em" type="cite"><div><div class="h5"><div dir="ltr">Hi Guys,<div><br></div><div>I am using Guvnor 5.5. For moving packages between environments, I am doing an export, and then import in the new package. I have a lof of assets in each package. I am using the DB storage for the jcr repository.</div>
<div><br></div><div>After some months, the DB has grown a LOT! (like 3.5GB).</div><div><br></div><div>Is there a way regularly clean the JCR history, or maybe disable JCR history as we are not using it at all?</div>
<div><br></div><div>These are the steps I did to remove the history and seems to work fine. Does is seem safe? Is there a better way?</div><div><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
1.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Export the entire repository via guvor.<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>2.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Delete all the packages.<u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>3.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Stop tomact<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>4.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>“truncate” the following guvnor tables:<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>a.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_binval<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>b.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_bundel<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>c.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_binval<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>d.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_bundle<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>5.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Restated tomcat</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
6.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Import what I exported on step #1</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br>
</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">Thanks!</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
Demian</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u></p><div><br></div></div></div></div></div><div class="">
_______________________________________________<br>rules-users mailing list<br><a href="http://user/SendEmail.jtp?type=node&node=4028026&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a><br><a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank" rel="nofollow" link="external">https://lists.jboss.org/mailman/listinfo/rules-users</a></div>
</blockquote></div><br></div><div class=""><br>_______________________________________________
<br>rules-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=4028026&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br><a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a>
<br>
<br>
<hr noshade size="1" color="#cccccc">
</div><div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><div class="">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
</div><a href="http://drools.46999.n3.nabble.com/rules-users-Guvnor-JCR-repository-tp4028025p4028026.html" target="_blank" rel="nofollow" link="external">http://drools.46999.n3.nabble.com/rules-users-Guvnor-JCR-repository-tp4028025p4028026.html</a>
</div><div class="HOEnZb"><div class="h5">
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To start a new topic under Drools: User forum, email <a href="/user/SendEmail.jtp?type=node&node=4028027&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from Drools, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://drools.46999.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></div></div></blockquote></div><br></div>
<div class="signature" style="margin-top:1em;color:#666666;font-size:11px;">
Nicolas Héron
</div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://drools.46999.n3.nabble.com/rules-users-Guvnor-JCR-repository-tp4028025p4028027.html">Re: [rules-users] Guvnor JCR repository</a><br/>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html">Drools: User forum mailing list archive</a> at Nabble.com.<br/>