To pile on here: When you denormalize you also get some functionality
that you do not get with Solr joins, they've been called "pseudo
joins" in Solr for a reason.
If you just use the simple approach of indexing the two tables then
joining across them you can't return fields from both tables in a
There is no way tell which is faster without trying it.
Query speed depends on the size of the data (rows), the complexity of the join,
which database, what kind of disk, etc.
Solr speed depends on the size of the documents, the complexity of your
analysis chains, what kind of disk, how much CP
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
wrote:
> Thanks Erick, Walter
> But I think join query will reduce the performance. Denormalization will be
> the better way than joi
Thank all for sharing your thoughts :)
On Thu, Aug 31, 2017 at 5:28 PM, Susheel Kumar
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 E
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
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?
>
>
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
wrote:
> Think about making a denormalized view, with all the fields needed in one
> table. That view
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
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"
wrote:
> Thanks Susheel for your response.
> Here is the scenario about which I am
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
O
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 qu
10 matches
Mail list logo
