<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On 9 Feb 2014, at 20:30, Nicolas Héron <<a href="mailto:nicolas.heron.java@gmail.com">nicolas.heron.java@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><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<span class="Apple-converted-space"> </span><br></div></div></div></blockquote>One of the main advantages of Git though is you can use traditional tools to manage this, such as rewriting history to squash commits.</div><div><blockquote type="cite"><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div dir="ltr"><div>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.<span class="Apple-converted-space"> </span><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 class="Apple-converted-space"> </span><span dir="ltr"><<a href="x-msg://322/user/SendEmail.jtp?type=node&node=4028027&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span>:<br><blockquote class="gmail_quote" style="border-left-width: 2px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 1em;"><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 type="cite" style="border-left-width: 2px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 1em;"><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>_______________________________________________<span class="Apple-converted-space"> </span><br>rules-users mailing list<span class="Apple-converted-space"> </span><br><a href="http://user/SendEmail.jtp?type=node&node=4028026&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a><span class="Apple-converted-space"> </span><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><span class="Apple-converted-space"> </span><br><br><hr noshade="" size="1"></div><div style="color: rgb(68, 68, 68); font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: 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: rgb(102, 102, 102); font-style: normal; font-variant: normal; font-weight: normal; font-size: 11px; font-family: tahoma, geneva, helvetica, arial, sans-serif; margin-top: 0.4em; line-height: 1.5em;">To start a new topic under Drools: User forum, email<span class="Apple-converted-space"> </span><a href="x-msg://322/user/SendEmail.jtp?type=node&node=4028027&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a><span class="Apple-converted-space"> </span><br>To unsubscribe from Drools,<span class="Apple-converted-space"> </span><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" target="_blank" link="external" style="font-style: normal; font-variant: normal; font-weight: normal; font-size: 9px; line-height: normal; font-family: serif;">NAML</a></div></div></div></blockquote></div><br></div><div class="signature" style="margin-top: 1em; color: rgb(102, 102, 102); font-size: 11px;">Nicolas Héron</div><br><hr align="left" width="300">View this message in context:<span class="Apple-converted-space"> </span><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<span class="Apple-converted-space"> </span><a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html">Drools: User forum mailing list archive</a><span class="Apple-converted-space"> </span>at<span class="Apple-converted-space"> </span><a href="http://nabble.com/">Nabble.com</a>.<br>_______________________________________________<br>rules-users mailing list<br><a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br><a href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a></div></blockquote></div><br></body></html>