Re: Index relational database

2017-08-31 Thread Erick Erickson
t;> On Mon, Aug 28, 2017 at 7:02 PM, Susheel Kumar >>>>> wrote: >>>>> >>>>>> Hello Renuka, >>>>>> >>>>>> I would suggest to start with your use case(s). May be start with your >>>>>> first use ca

Re: Index relational database

2017-08-31 Thread Walter Underwood
e 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.) >>>>> >>>

Re: Index relational database

2017-08-31 Thread David Hastings
, 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 > > >>>> > > >>> > > >> > > > > >

Re: Index relational database

2017-08-31 Thread Renuka Srishti
t; >>> 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,

Re: Index relational database

2017-08-31 Thread Susheel Kumar
gt; > >>> 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 > > >>>> > > >>> > > >> > > > > >

Re: Index relational database

2017-08-31 Thread Renuka Srishti
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 > >>>> > >>> > >> > >

Re: Index relational database

2017-08-30 Thread Walter Underwood
gt; >>> 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 >>>> >>> >>

Re: Index relational database

2017-08-30 Thread Erick Erickson
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 > > > > > >

Re: Index relational database

2017-08-30 Thread Renuka Srishti
u 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 > > >

Re: Index relational database

2017-08-28 Thread Susheel Kumar
Srishti wrote: > Hii, > > What is the best way to index relational database, and how it impacts on > the performance? > > Thanks > Renuka Srishti >

Index relational database

2017-08-28 Thread Renuka Srishti
Hii, What is the best way to index relational database, and how it impacts on the performance? Thanks Renuka Srishti