Hi Otis, Thanks. Was thinking along those lines. But having two indexes will hurt my search.
1 . Searching fields that belong only to the personal details should result in 5 resumes begin shown for the guy (if he has 5). But now it will only show 1 link to the personal details and no resumes. 2 . Searching fields that belong to the personal details and resume details will result in 2 sets of results which I will have to manually combine using text processing. Can I avoid doing this? Thanks, Gavin On Sun, 2008-01-20 at 22:52 -0800, Otis Gospodnetic wrote: > You could have 2 separate indices tied with a common field (a la FK->PK). > Then you only need to change the item you are updating. > > Otis > -- > Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch > > ----- Original Message ---- > From: Gavin <[EMAIL PROTECTED]> > To: solr-user <solr-user@lucene.apache.org> > Sent: Monday, January 21, 2008 12:09:23 AM > Subject: Storing Related Data - At Different Times > > Hi, > In the web application we are developing we have two sets of > details. > The personal details and the resume details. We allow 5 different > resumes to be available for each user. But we want the personal details > to remain same for each 5 resumes. Personal details are added at > registration time. After than for each resume we want link personal > details. This is a simple join in the db. But how do we achieve this in > Solr. The problem is when personal details are changed we will have to > update all 5 resumes. > > I read the thread "Some sort of join in SOLR?". But not sure this > answers my problem. Would very much appreciate some sort of help on > this > one. > > Thanks, -- Gavin Selvaratnam, Project Leader hSenid Mobile Solutions Phone: +94-11-2446623/4 Fax: +94-11-2307579 Web: http://www.hSenidMobile.com Make it happen Disclaimer: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. The content and opinions contained in this email are not necessarily those of hSenid Software International. If you have received this email in error please contact the sender.