[jboss-user] [jBPM] - Re: StatefulKnowledgeSession signalEvent method

Geoff Pole [http://community.jboss.org/people/instanceof] created the discussion "Re: StatefulKnowledgeSession signalEvent method" To view the discussion, visit: http://community.jboss.org/message/627079#627079 -------------------------------------------------------------- Hi, In case this helps others. I had this slightly backwards. It wasn't the second signal event call that was making the ProcessInstancesWaitingForEvent run. Instead this query appears to run every time a process enters and 'End' node. Presumably it does this so that it can find any workflows that may be listening for an End event. I don't know the reason why the ProcessInstancesWaitingForEvent runs so slowly (Oracle 11g) when there are many workflow instances that are waiting for events, but I did find that by applying this index reduced the running time from around 45 seconds to under 1 second with 20000 workflow instances. CREATE unique INDEX  idx_eventtypes_id_elem    ON EventTypes (instanceid, element) I tested this up to 100000 workflow instances and the query still runs sub second. Cheers, Geoff -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/627079#627079] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]