lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amit Nithian <>
Subject Re: Use of Solr as primary store for search engine
Date Wed, 04 Jul 2012 19:17:42 GMT

Thanks for your response! Were you using the SQL database as an object
store to pull XWiki objects or did you have to execute several queries
to reconstruct these objects? I don't know much about them sorry..
Also for those responding, can you provide a few basic metrics for me?
1) Number of nodes receiving queries
2) Approximate queries per second
3) Approximate latency per query

I know some of this may be sensitive depending on where you work so
reasonable ranges would be nice (i.e. sub-second isn't hugely helpful
since 50,100,200 ms have huge impacts depending on your site).

Thanks again!

On Wed, Jul 4, 2012 at 1:09 AM, Paul Libbrecht <> wrote:
> Amit,
> not exactly a response to your question but doing this with a lucene index on
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 à 09:54, Amit Nithian a écrit :
>> Hello all,
>> 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?
>> 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.
>> 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.
>> Thanks!
>> Amit

View raw message