Re: Relational data

Thank's Ahmet and Tomás. It worked like a charm. * -- * *"E conhecereis a verdade, e a verdade vos libertará." (João 8:32)* *andre.maldonado*@gmail.com (11) 9112-4227

Re: Relational data

You could use the grouping feature, depending on your needs: http://wiki.apache.org/solr/FieldCollapsing 2012/3/12 André Maldonado > Hi. > > I need to setup an index that have relational data. This index will be for > houses to rent, where the user will search for date, price,

Re: Relational data

> The problem is that the same house can have different prices > for different > dates. > > If I denormalyze this data, I will show the same house > multiple times in > the resultset, and I don't want this. > > So, for example: > > House  Holyday       Price per > day > 1          Xmas      >  

Relational data

Hi. I need to setup an index that have relational data. This index will be for houses to rent, where the user will search for date, price, holydays (by name), etc. The problem is that the same house can have different prices for different dates. If I denormalyze this data, I will show the same

Re: how to handle large relational data in Solr

?  Basically on search on product > attributes and a second search on the attributes of related accessories? > > many thanks, > Jonathan > > From: Robert Stewart [bstewart...@gmail.com] > Sent: Thursday, October 20, 2011 12:05 PM >

Re: how to handle large relational data in Solr

.com/ > >From: Jonathan Carothers >To: "solr-user@lucene.apache.org" >Sent: Thursday, October 20, 2011 1:23 PM >Subject: RE: how to handle large relational data in Solr > >Actually, that's the root of my concern.  It looks like it product will >av

RE: how to handle large relational data in Solr

20, 2011 12:05 PM To: solr-user@lucene.apache.org Subject: Re: how to handle large relational data in Solr If your "documents" are products, then 100,000 documents is a pretty small index for solr. Do you know approximately how many accessories are related to each product on avera

Re: how to handle large relational data in Solr

10:50 AM > To: solr-user@lucene.apache.org > Subject: RE: how to handle large relational data in Solr > > I would not recommend removing your relational database altogether. You > should treat that as your system of record. By replacing it, you are forcing > Solr to store the un

RE: how to handle large relational data in Solr

: how to handle large relational data in Solr I would not recommend removing your relational database altogether. You should treat that as your system of record. By replacing it, you are forcing Solr to store the unmodified value for everything even when not needed. You also lose normalization

RE: how to handle large relational data in Solr

aroth...@amentra.com] Sent: Thursday, October 20, 2011 10:12 AM To: solr-user@lucene.apache.org Subject: how to handle large relational data in Solr All, We are attempting to convert a fairly large relational database into Solr index(es). There are ~100,000 products with ~1,000,000 accessories that c

how to handle large relational data in Solr

All, We are attempting to convert a fairly large relational database into Solr index(es). There are ~100,000 products with ~1,000,000 accessories that can be related to any number of the products. So if I include the search terms and the relationships in the same index, we're looking at a pre

Re: Unified search of relational data on Solr?

document) and > >> index it. > >> > >> Otis > >> -- > >> Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch > >> > >> > >> > >> > >> > >> From: Senthil Kumar &

Re: Unified search of relational data on Solr?

t; >> >> >> >> ____ >> From: Senthil Kumar >> To: solr-user@lucene.apache.org >> Sent: Thursday, February 19, 2009 1:20:23 PM >> Subject: Unified search of relational data on Solr? >&

Re: Unified search of relational data on Solr?

; > > From: Senthil Kumar > To: solr-user@lucene.apache.org > Sent: Thursday, February 19, 2009 1:20:23 PM > Subject: Unified search of relational data on Solr? > > Hi, > > How to index relational data in Solr which can not be m

Re: Unified search of relational data on Solr?

: Unified search of relational data on Solr? Hi, How to index relational data in Solr which can not be merged as a single file for some reasons? We have two kinds of XMLs indexed in Solr, 1_persona 1_addr washington Our

Unified search of relational data on Solr?

Hi, How to index relational data in Solr which can not be merged as a single file for some reasons? We have two kinds of XMLs indexed in Solr, 1_persona 1_addr washington Our aim to get a list of persons living in

Re: Best practice for storing relational data in Solr

I've found that Solr running on modest hardware (a 2.4 GHz PC running Windows XP Pro for testing changes) is able to index about 23,000 records in under three minutes. Assuming you aren't going to make too many typos in your naming, you should be fine just doing the re-indexing. Try timing yo

Re: Best practice for storing relational data in Solr

Short answer: It depends. Long answer: It depends on whether you want to be able to search on. If you need to search by recruiter name then obviously you'll need to index it, if you don't you only really need to index the most relevent db identifier, then work out the relations from that in MySQL (

Best practice for storing relational data in Solr

Hi all, This is a (possibly very naive) newbie question regarding Solr best practice... I run a website that displays/stores data on job applicants, together with information on where they came from (e.g. which recruiter), which office they are applying to, etc. This data is stored in a m