7 Replies Latest reply: Apr 27, 2012 2:19 PM by Clebert Suconic RSS

Is there a way for us to create a subscription based on an IN clause like filter?

Connie Yang Newbie

Is there way for us to create a subscription based on an in-clause like message filter without sacrificing performance and such in HornetQ?

 

Here's my use case, our consumers want to create a subscription to receive messages that are associated/tagged with a set of predefined unique numeric ids which don't belong to a specific range or pattern.  Also, the filter set can be big (in the order of thousands).

 

My first thought was to use an IN clause like filter, but not sure if this is supported in HornetQ, or rather SQL92.  After thinking through a bit, I thought about having our consumer to create multiple subscriptions and sort the filter set.  Then, the subscriptions can be filtered on a specific range of numbers.

 

Is there better way for doing this?

 

Thanks in advance.