lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dennis Gearon <gear...@sbcglobal.net>
Subject Re: Solr relational date & cost data
Date Mon, 21 Jun 2010 12:51:14 GMT
Interesting, pre calculated, different prices on different days of the week? So houses are
like groceries, huh? :-)
Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life,
  otherwise we all die.

Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php


--- On Mon, 6/21/10, Peter Karich <peathal@yahoo.de> wrote:

> From: Peter Karich <peathal@yahoo.de>
> Subject: Re: Solr relational date & cost data
> To: solr-user@lucene.apache.org
> Date: Monday, June 21, 2010, 4:33 AM
> Do you need to search (or facetting,
> filtering) through the dates or costs?
> Maybe you can store only the max and min price and the
> available-date-range in solr?
> And then get detailed information from an additional
> database-query?
> 
> Peter.
> 
> > I want to be able to store property information in
> Solr, including
> > descriptions, tags, keywords etc. This is really easy
> to do.
> >
> > But also I need to be able to store a range of dates
> that the property
> > is available along with costings. Currently we're
> using MySQL for this
> > storing a row for every possible date e.g. 21-Jun-2010
> and a cost for
> > that date.
> >
> > I was wondering if there would be a simple way of
> recreating this in
> > Solr, storing all property info + dates + costs and be
> able to reference
> > them, or would I need to store all property info +
> single date + cost
> > for that date?
> >
> > Storing individual dates would mean we have over
> 4,000,000 records which
> > I think we could handle, but I wondered if someone
> might have a better
> > idea about it.
> >
> > Thanks in advance and apologies for my noobiness.
> 
> 

Mime
View raw message