Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-07-02 Thread zeeshan
Hi Laune ! Finally I am able to read 100 thousand records as rule through reading CSV. Thanks very very much for your precious time. I would also like to thank Mike and other guys who have contributed in this thread. Thanks !!! :) -- View this message in context: http://drools.46999.n3.na

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Davide Sottara
Out of curiosity, are you enumerating every possible combination of your decision variables in that table? Is the decision criteria really so fine-grained that you can't aggregate/accumulate/regress/etc... them in a more structured way? -- View this message in context: http://drools.46999.n3.na

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Chris Selwyn
Please don't let me stop you implementing Wolfgang's solution... I'm sure that it is the best solution for implementation in a rules engine. I was just thinking "outside of the box" for a moment. However, if you are not comfortable with coding outside of a rules engine then by all means ignore m

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Wolfgang Laun
On 19/06/2012, Sangram Jethy wrote: > Hi Laun > > Tnks for dis wonderfl solution ...I guess our performance issue is solved > as of now..But I got a small query over it. > > 1) When 10k records were there in the DT, the DT was to compile and all > these 10k rules now stays in the production memory

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Sangram Jethy
Hi Laun Tnks for dis wonderfl solution ...I guess our performance issue is solved as of now..But I got a small query over it. 1) When 10k records were there in the DT, the DT was to compile and all these 10k rules now stays in the production memory.And we were inserting a single fact in working m

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread zeeshan
Hi Chris ! If you can elaborate it more, I will really try to implement it. I was just started giving a try to Laune's way. thanks !! -- View this message in context: http://drools.46999.n3.nabble.com/Hibernate-Configuration-with-Drools-5-4-tp4017981p4018056.html Sent from the Drools: User foru

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Chris Selwyn
If you'll pardon the heresy... It sounds to me like the whole thing can be solved with an appropriately loaded hashtable without any need for a rules engine at all! Chris On 19/06/2012 11:54, Wolfgang Laun wrote: > On 19/06/2012, zeeshan wrote: >> Hi Laune, >> >> >> >> Thanks very much for you

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Wolfgang Laun
On 19/06/2012, zeeshan wrote: > Hi Laune, > > > > Thanks very much for your response. We would like to try and implement > Option 3. > > We assume that the implementation involves setting up individual rows in > the > excel as a collection of objects and using the From keyword to look up the > ou

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread zeeshan
Hi Laune, Thanks very much for your response. We would like to try and implement Option 3. We assume that the implementation involves setting up individual rows in the excel as a collection of objects and using the From keyword to look up the output value/row we want based on the input parame

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Vincent LEGENDRE
To me, the problem discussed in this thread highlights a deeper problem (more than DT compile time) : using DT as data storage is bad. Wolfgang's post demonstrate this fact. Previous posts demonstrate another problem : having 50k, 100k rules with the very same (basic) structure demonstrate that

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-19 Thread Wolfgang Laun
The problem discussed in this thread arises from a spreadsheet where 6 values are to be matched (==) with fact object properties, resulting in the setting of a single attribute in the field. The spreadsheet has 26400 lines, resulting in so many rules that merely differ in the values of the literals

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-18 Thread zeeshan
*Hi Vincent ! 50k records is very less for the projects scaling over 1 lac(100k) records and when I started working on Drools, I was assured with performance and ease in developing business rule. But if xls format(DTs) not even supporting 26k records , how can I implement it for client requirement

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-18 Thread Vincent LEGENDRE
again . - Mail original - De: "Wolfgang Laun" À: "Rules Users List" Envoyé: Lundi 18 Juin 2012 19:40:25 Objet: Re: [rules-users] Hibernate Configuration with Drools 5.4 Relax, Vincent, it was sent due to my explicit request, and it was a maller size version. I'v

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-18 Thread Wolfgang Laun
boss.org > *Envoyé: *Lundi 18 Juin 2012 08:19:27 > *Objet: *Re: [rules-users] Hibernate Configuration with Drools 5.4 > > > Hi Laune ! > > I have mailed you my spreadsheet at ur gmail id. > > Thanks ! > > -- > View this message in context: > http://drools.46

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-18 Thread Vincent LEGENDRE
- ask questions that are related to rules, and not java heap size limits ... - Mail original - De: "zeeshan" À: rules-users@lists.jboss.org Envoyé: Lundi 18 Juin 2012 08:19:27 Objet: Re: [rules-users] Hibernate Configuration with Drools 5.4 Hi Laune ! I have mailed you my sp

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-17 Thread zeeshan
Hi Laune ! I have mailed you my spreadsheet at ur gmail id. Thanks ! -- View this message in context: http://drools.46999.n3.nabble.com/Hibernate-Configuration-with-Drools-5-4-tp4017981p4018017.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-15 Thread zeeshan
Hi Laune and thanks for replying ! We have a set of Insurance Rate Tables setup as Drools Decision tables. One of these is large – 50,000 rows – These are setup as individual line items in a single Decision table [four parameters whose input value leads to a result value]. We notice that while lo

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-15 Thread Wolfgang Laun
You have to distinguish between the time required for building the KnowledgeBase from the decision table, and the time required for processing a fact with the 50,000 rules. If the former is the problem, serializing the KnowledgeBase is the best you can do, and you don't need Hibernate. If the lat

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-15 Thread zeeshan
Hi Mike and thanks for replying ! Actually I am planning to store rules in database because calling from excel sheet effects performance drastically. So kindly guide me to migrate excel sheet rules to database using Hibernate or please suggest me other possible options. Thanks !! -- View this me

Re: [rules-users] Hibernate Configuration with Drools 5.4

2012-06-15 Thread Michael Anstis
Your requirement is not clear. What do you want to store in a database? Rules, Facts? Is "50,000 records in one of my decision tables" 50k rows or 50k facts? If facts what makes you thinking moving them from in-memory objects to a database will bring any performance gains? On 15 June 2012 07:38

[rules-users] Hibernate Configuration with Drools 5.4

2012-06-14 Thread zeeshan
Hi All ! I want to use Hibernate for database persistence in my drools project. Please suggest me the steps. I am using 5.4.0 final version. Which version of hibernate I shall use whether 3.1 or Annotation one.?? I have idea about 3.1. Actually I am having 50,000 records in one of my Decision