Hello, We've been working extensively with Solr as a 'standard' search service. However, recently, we had a volume problem displaying time series (by instance, sentiment of a brand by date), pulling data from a highly denormalized database. Indexing a view of this database, coupled with faceting (god bless faceting :D) by the date field, gave us directly every data series we needed to display, in a time an order of magnitude faster than the database (I guess the 'regular' way) approach. Roughly 1-2 seconds 'playing' with 300.000 points (Solr approach) vs nearly 45 seconds in the DB approach.
Amazing thing is that we are not using Solr as a 'text' indexer. The approach is more like a 'faceter' of data and it is surprisingly fast. Can be a good case study of a non-standard way of using Solr or in the Solr vs Database 'war' :D >From now on, we're adopting this approach every time we have to display Flash graphs of time series in front-end projects Our field of work is mainly text crawling, analysis and indexing, including sentiment analysis, focused crawling, natural language understanding, concept extraction... Thanks, Oscar On Mon, Feb 1, 2010 at 6:08 PM, Otis Gospodnetic <otis_gospodne...@yahoo.com > wrote: > Hello everyone, > > Thanks to all who emailed me so far. This is just another reminder for > those who missed the first email below. Please let us know if you'd like to > contribute a piece to Solr in Action about your interesting use of Solr. > > Thanks, > Otis > ---- > Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch > Hadoop ecosystem search :: http://search-hadoop.com/ > > > > ----- Original Message ---- > > From: Otis Gospodnetic <otis_gospodne...@yahoo.com> > > To: solr-user@lucene.apache.org > > Sent: Thu, January 14, 2010 2:09:41 PM > > Subject: Contributors - Solr in Action Case Studies > > > > Hello, > > > > We are working on Solr in Action [1]. One of the well received chapters > from > > LIA #1[2] was the Case Studies chapter, where external contributors > described > > how they used Lucene. We are getting good feedback about this chapter > from LIA > > #2 reviewers, too. > > > > Solr in Action also has a Case Studies chapter, and we are starting to > look for > > contributors. > > > > If you are using Solr in some clever, interesting, or unusual way and are > > willing to share this information, please get in touch. 5 to max 10 > pages (soft > > limits) per study is what we are hoping for. Feel free to respond on the > list > > or reply to me directly. > > > > [1] http://www.manning.com/catalog/undercontract.html > > [2] http://www.manning.com/hatcher2/ and > http://www.manning.com/hatcher3/ > > > > Thanks, > > Otis > > -- > > Sematext -- http://sematext.com/ -- Solr - Lucene - Nutch > > -- Whether it's science, technology, personal experience, true love, astrology, or gut feelings, each of us has confidence in something that we will never fully comprehend. --Roy H. William
