Hi Alan, at my job we had a really succesful implementation similar to what you are proposing. With a classic RDBM, we hit serious performance issues so, we moved to solr to display time series of data. The 'trick' was to facet on a date field, to get 'counts' of data for a time series on a specific field but don't know if you could be more specific about your data schema to see it this applies.
Kind regards, Oscar On Sat, Dec 3, 2011 at 6:10 PM, Alan Miller <alan.mill...@gmail.com> wrote: > Hi, > > I have a webapp that plots a bunch of time series data which > is just a series of doubles coupled with a timestamp. > > Every chart in my webapp has a chart_id in my db and i am wondering if it > would be > effective to usr solr to serve the data to my app instead of keeping the > data in my rdbms. > > Currently I'm using hadoop to calc and generate the report data and the > sticking it in my > rdbms but I could use solrj client to upload the data to a solr index > directly. > > I know solr if for indexing text documents but would it be effective to use > solr in this way? > > I want to query by chart_id and get back a series of timestamp:double > pairs. > > Regards > Alan > -- 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
