On 9/11/2018 8:35 PM, John Smith wrote:
The problem is that the math isn't a simple case of adding up all the row counts. These are "left outer join"s. In sql, it would be this query:
I think we'll just have to conclude that I do not understand what you are doing. I have no idea what "left outer join" even means, how it's different than a join that's NOT "left outer".
I will say this: Solr is not very efficient at joins, and there are a bunch of caveats involved. It's usually better to go with a flat document space for a search engine.
Thanks, Shawn
