Paul, 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! Amit On Wed, Jul 4, 2012 at 1:09 AM, Paul Libbrecht <p...@hoplahup.net> wrote: > 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 à 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 >
