Hi Efim,
Thanks for the suggestion.
I had actually done exactly what you suggest to work around the problem in this specific scenario, but it was really just meant as an example; I have other cases where it's not desirable to do this, such as having a number of conditions based on different collections. Using lots of joins in that case causes performance issues due to the cartesian product problem.
Regards, Ben.
|