First, it's often best, by far, to denormalize the data in your solr index, that's what I'd explore first.
If you can't do that, the join query parser might work for you. On Aug 30, 2017 4:49 AM, "Renuka Srishti" <renuka.srisht...@gmail.com> wrote: > Thanks Susheel for your response. > Here is the scenario about which I am talking: > > - Let suppose there are two documents doc1 and doc2. > - I want to fetch the data from doc2 on the basis of doc1 fields which > are related to doc2. > > How to achieve this efficiently. > > > Thanks, > > Renuka Srishti > > > On Mon, Aug 28, 2017 at 7:02 PM, Susheel Kumar <susheel2...@gmail.com> > wrote: > > > Hello Renuka, > > > > I would suggest to start with your use case(s). May be start with your > > first use case with the below questions > > > > a) What is that you want to search (which fields like name, desc, city > > etc.) > > b) What is that you want to show part of search result (name, city etc.) > > > > Based on above two questions, you would know what data to pull in from > > relational database and create solr schema and index the data. > > > > You may first try to denormalize / flatten the structure so that you deal > > with one collection/schema and query upon it. > > > > HTH. > > > > Thanks, > > Susheel > > > > On Mon, Aug 28, 2017 at 8:04 AM, Renuka Srishti < > > renuka.srisht...@gmail.com> > > wrote: > > > > > Hii, > > > > > > What is the best way to index relational database, and how it impacts > on > > > the performance? > > > > > > Thanks > > > Renuka Srishti > > > > > >
