lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Renuka Srishti <renuka.srisht...@gmail.com>
Subject Re: Index relational database
Date Wed, 30 Aug 2017 11:49:27 GMT
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 <susheel2777@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.srishti93@gmail.com>
> wrote:
>
> > Hii,
> >
> > What is the best way to index relational database, and how it impacts on
> > the performance?
> >
> > Thanks
> > Renuka Srishti
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message