joins in solr cloud - good or bad idea?

2013-07-08 Thread Marcelo Elias Del Valle
Hello all, I am using Solr Cloud today and I have the following need: - My queries focus on counting how many users attend to some criteria. So my main document is user (parent table) - Each user can access several web pages (a child table) and each web page might have several

Re: joins in solr cloud - good or bad idea?

2013-07-08 Thread Roman Chyla
Hello, The joins are not the only idea, you may want to write your own function (ValueSource) that can implement your logic. However, I think you should not throw away the regex idea (as being slow), before trying it out - because it can be faster than the joins. Your problem is that the number

Re: joins in solr cloud - good or bad idea?

2013-07-08 Thread Marcelo Elias Del Valle
Roman, The video was very clarifying and I realized block joins would be a great fit for my problem. However, I got worried about the size of the block... I could have 10 million childs for 1 parent, for instance. Althout this could stay in the same shard, do you guys think it would be a huge