when indexing a relational database its generally always best to denormalize it in a view or in your indexing code
On Thu, Aug 31, 2017 at 3:54 AM, Renuka Srishti <renuka.srisht...@gmail.com> wrote: > Thanks Erick, Walter > But I think join query will reduce the performance. Denormalization will be > the better way than join query, am I right? > > > > On Wed, Aug 30, 2017 at 10:18 PM, Walter Underwood <wun...@wunderwood.org> > wrote: > > > Think about making a denormalized view, with all the fields needed in one > > table. That view gets sent to Solr. Each row is a Solr document. > > > > It could be implemented as a view or as SQL, but that is a useful mental > > model for people starting from a relational background. > > > > wunder > > Walter Underwood > > wun...@wunderwood.org > > http://observer.wunderwood.org/ (my blog) > > > > > > > On Aug 30, 2017, at 9:14 AM, Erick Erickson <erickerick...@gmail.com> > > wrote: > > > > > > 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 > > >>>> > > >>> > > >> > > > > >
