One, take off your RDBMS cap <G>... DB folks regularly reject the idea of de-normalizing data to make best use of Solr, but that's what I would explore first. Yes, this repeats the, in your case, vendor information perhaps many times, but try that first, even though that causes you to update multiple customers whenever a vendor changes. You haven't specified how many customers and vendors you're talking abou there, but unless the total number of documents (where each document is a customer+vendor combination) is multiple tens of millions, you probably will be fine.
You can get a list of just customers by using grouping where you group on customer, although that may not be the most efficient. You could index a field, call it "cust_filter" that was set to true for the first customer/vendor you indexed and false (or just left out) for all the rest and q=blahblah&fq=cust_filter:true. Hope that helps Erick On Wed, Oct 24, 2012 at 12:01 PM, Marcelo Elias Del Valle <mvall...@gmail.com> wrote: > Hello, > > I am new to Solr and I have a scenario where I want to use it, but I > might be misunderstanding some concepts. I will explain what I want here, > if someone has a solution for this, I would gladly accept the help. > I have a core indexing customers. I have another core indexing vendors. > Both are related to each other. > Here is what I want to do in my application: I want to find all the > customers that follow some criteria and them find the vendors related to > them. > > My first option was to to have just vendor core and in for each > document in vendor core I would have all the customers related to it. > However, I would write the same customer several times to the index, as > more than one vendor could be related to the same customer. Besides, I > wonder how would I write a query to list just the different customers. > Another problem is that I update customers in a different frequency I > update vendors, but have vendor + customers in a single document would obly > me to do the full update. > > Does anyone have a good solution for this I am not being able to see? I > might be missing some basic concept here... > > Thanks, > -- > Marcelo Elias Del Valle > http://mvalle.com - @mvallebr
