Re: Searching for something based on an Array values
Yes, in case of many-to-many relationship there is no way to collocate if both entities are stored in partitioned caches. I see two possible workarounds for that:
- Put one of entities into replicated cache so that it's available on all nodes and therefore doesn't need to be collocated.
- Denormalize the data and use one-to-many relationship instead. You will have to duplicate some data, but this approach doesn't require to utilize replicated caches.
Can you please describe in more detail what you mean by 'Bi-Cache'?