Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1084)
Subject: Re: Use of Solr as primary store for search engine
From: Paul Libbrecht <paul@hoplahup.net>
In-Reply-To: 
 <CAEsaxUr7=jDJAd78_dKHjFMFFgN+rvWOCW1ORJiEWj5TXLHLTg@mail.gmail.com>
Date: Wed, 4 Jul 2012 10:09:21 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <8B5F9E9F-C933-4AE4-BDE0-9AF762E5343C@hoplahup.net>
References: 
 <CAEsaxUr7=jDJAd78_dKHjFMFFgN+rvWOCW1ORJiEWj5TXLHLTg@mail.gmail.com>
To: solr-user@lucene.apache.org

Amit,

not exactly a response to your question but doing this with a lucene =
index on i2geo.net has resulted in considerably performance boost =
(reading from stored-fields instead of reading from the xwiki objects =
which pull from the SQL database). However, it implied that we had to =
rewrite anything necessary for the rendering, hence the rendering has =
not re-used that many code.

Paul


Le 4 juil. 2012 =E0 09:54, Amit Nithian a =E9crit :

> Hello all,
>=20
> I am curious to know how people are using Solr in conjunction with
> other data stores when building search engines to power web sites (say
> an ecommerce site). The question I have for the group is given an
> architecture where the primary (transactional) data store is MySQL
> (Oracle, PostGres whatever) with periodic indexing into Solr, when
> your front end issues a search query to Solr and returns results, are
> there any joins with your primary Oracle/MySQL etc to help render
> results?
>=20
> Basically I guess my question is whether or not you store enough in
> Solr so that when your front end renders the results page, it never
> has to hit the database. The other option is that your search engine
> only returns primary keys that your front end then uses to hit the DB
> to fetch data to display to your end user.
>=20
> With Solr 4.0 and Solr moving towards the NoSQL direction, I am
> curious what people are doing and what application architectures with
> Solr look like.
>=20
> Thanks!
> Amit