Thank all for sharing your thoughts :) On Thu, Aug 31, 2017 at 5:28 PM, Susheel Kumar <susheel2...@gmail.com> wrote:
> Yes, if you can avoid join and work with flat/denormalized structure then > that's the best. > > 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 > > > >>>> > > > >>> > > > >> > > > > > > > > >
