Forum Stats

  • 3,826,581 Users
  • 2,260,667 Discussions


Performance referencing a coherence cache from an EPL Statement


I am trying to use a cache with composite key from an EPL statement and I have doubts about the performance as I think that CEP is using AllFilter with KeyExtractor to get the data from cache. If you have a composite key and you use it from EPN the code have to be something like this:

AllFilter(EqualsFilter(KeyExtractor(extractor=.getProperty1()), value1), EqualsFilter(KeyExtractor(extractor=.getProperty2()), value2), EqualsFilter(KeyExtractor(extractor=.getProperty3()), value3))

Am I right? Is this a optimal procedure or can I extract the values in another way? I suppose that the best choice is getting the value directly with the key but I don't know if is possible.

My Oracle Stream Analytics version is


This discussion has been closed.