<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 17 Aug 2014, at 01:42, Jan Rose <<a href="mailto:ufos@comcast.net">ufos@comcast.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div bgcolor="#FFFFFF" 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></div><div>Mark, thanks for responding. Do you have a recommendation as to how much I should </div><div>increase the perm gen space? </div></div></blockquote>The more rules, the more permgen space. So there is no recommendation, other than “enough”.<br><blockquote type="cite"><div bgcolor="#FFFFFF" 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> Also, is there anything else I can do to run my decision tables more efficiently?</div></div></blockquote>You can try using the MVEL dialect for your decision table - this uses reflection based executions, instead of code and uses less perm gen, in return for using more heap.</div><div><a href="http://lists.jboss.org/pipermail/rules-users/2011-November/022912.html">http://lists.jboss.org/pipermail/rules-users/2011-November/022912.html</a></div><div><br></div><div>Mark<br><blockquote type="cite"><div bgcolor="#FFFFFF" 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><br></div><div>Jan</div><div><br></div><div><br><pre><font class="Apple-style-span" face="Helvetica">try increasing your perm gen space.</font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"> Mark On 16 Aug 2014, at 04:11, Jan Rose <<a href="https://lists.jboss.org/mailman/listinfo/rules-users">ufos at comcast.net</a></span></font><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;">> wrote: ><i> </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i>Would like some advice regarding using Decision Tables in DROOLS 5.6.0 Final. </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> We have decision tables with over 12,000 rows. </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> It is a basic ‘look-up’ table with 3 conditions and 2 actions. </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> The conditions are, for example: Company = X Dept = X Class = X then value = X and log X.</i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> When I reduced the number of rows to approx. 500 . .. it works.<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>I have set the max memory in the JVM to 2 gigs. </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> We have tried compiling the decision tables using the spreadsheet compiler as well as the decision table compiler.<span class="Apple-converted-space"> </span></i></span></font><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;">><i> </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i>Below is the error when using the decision table compiler. </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i> However, we get the same PermGen space error with the spreadsheet compiler.<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span></i></span></font><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;">><i> </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i>Obviously, we need to be able to have more than 500 rows in our decision table(s). Any advice would be appreciated. </i>><i><span class="Apple-converted-space"> </span></i>><i> </i></span></font></pre><pre><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="white-space: normal;"><i>Aug 14, 2014 6:33:09 PM com.macys.test.rules.engine.AttribDecisionTbl main<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>INFO: found file:c:\attribute-data.xls<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>Aug 14, 2014 6:33:10 PM com.macys.test.test_drools.RuleRunner loadRules<span class="Apple-converted-space"> </span></i>><i>INFO: Loading file: log-rules.drl<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>Aug 14, 2014 6:33:10 PM com.macys.test.test_drools.RuleRunner loadRuleFile<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>INFO: found rule file:log-rules.drl<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>Aug 14, 2014 6:33:11 PM com.macys.test.test_drools.RuleRunner loadRules<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>INFO: Loading file: AttributeRules-MDSLife-V1.xls<span class="Apple-converted-space"> </span></i>><i>Aug 14, 2014 6:33:11 PM com.macys.test.test_drools.RuleRunner loadExcelRules<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>INFO: found file:AttributeRules-MDSLife-V1.xls<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>Exception in thread "main" java.lang.OutOfMemoryError: PermGen space<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at java.lang.ClassLoader.defineClass1(Native Method)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at java.lang.ClassLoader.defineClass(ClassLoader.java:800)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.rule.JavaDialectRuntimeData$PackageClassLoader.fastFindClass(JavaDialectRuntimeData.java:624)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.util.CompositeClassLoader$CachingLoader.load(CompositeClassLoader.java:254)<span class="Apple-converted-space"> </span></i>><i>at org.drools.util.CompositeClassLoader$CachingLoader.load(CompositeClassLoader.java:237)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.util.CompositeClassLoader.loadClass(CompositeClassLoader.java:88)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at java.lang.ClassLoader.loadClass(ClassLoader.java:358)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.rule.JavaDialectRuntimeData.wire(JavaDialectRuntimeData.java:434)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.rule.JavaDialectRuntimeData.wire(JavaDialectRuntimeData.java:429)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.rule.JavaDialectRuntimeData.onBeforeExecute(JavaDialectRuntimeData.java:257)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.rule.DialectRuntimeRegistry.onBeforeExecute(DialectRuntimeRegistry.java:139)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.compiler.PackageBuilder.reloadAll(PackageBuilder.java:1202)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.compiler.PackageBuilder.compileAllRules(PackageBuilder.java:951)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.compiler.PackageBuilder.addPackage(PackageBuilder.java:938)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.compiler.PackageBuilder.addPackageFromDecisionTable(PackageBuilder.java:451)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:715)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:51)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at com.macys.test.test_drools.RuleRunner.loadExcelRules(RuleRunner.java:161)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at com.macys.test.test_drools.RuleRunner.loadRules(RuleRunner.java:53)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at com.macys.test.test_drools.RuleRunner.runStatelessRules(RuleRunner.java:217)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>at com.macys.test.rules.engine.AttribDecisionTbl.main(AttribDecisionTbl.java:99)<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span></i>><i>_______________________________________________<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span>rules-users mailing list<span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span><a href="https://lists.jboss.org/mailman/listinfo/rules-users">rules-users at lists.jboss.org</a><span class="Apple-converted-space"> </span></i>><i><span class="Apple-converted-space"> </span><a href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><span class="Apple-converted-space"> </span></i>-------------- next part -------------- An HTML attachment was scrubbed... URL:<span class="Apple-converted-space"> </span><a href="http://lists.jboss.org/pipermail/rules-users/attachments/20140816/e86011b7/attachment-0001.html">http://lists.jboss.org/pipermail/rules-users/attachments/20140816/e86011b7/attachment-0001.html</a></span></font></pre><pre></pre><pre></pre><pre></pre><pre></pre><pre></pre><pre><font class="Apple-style-span" face="Times" size="3">
</font></pre><div style="font-family: Times; font-size: inherit;"><br></div>Sent from my iPad</div>_______________________________________________<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>