Re: [rules-users] Getting data from a relational database

As a general rule, query the database in the Java code, and insert the objects retrieved as facts in the session. Then your LHS just needs to match on those facts. Either that or populate a global. If you have a stateless session, then you could get away with facts with getter methods which return collections and which are actually calling the database. However, it's horribly inefficient, more error prone (for one thing, you can't put a try-catch in your LHS) and less readable than performing the database queries up front in your Java code. fyi - On my last contract, the main reason I was able to achieve a ~1000x speed gain was removing database queries from the LHS and instead performing them up front and inserting the results as facts via the Java API. Steve On 30 Aug 2013, at 18:47, rtanikella <rtanikella(a)gmail.com&gt; wrote: