Any help? On 25 Jun 2013 13:35, "pradeep kumar" <pradeepkuma...@gmail.com> wrote:
> Sure, > > First of all thanks a lot everyone for very quick reply. > > We have a Ordering system which has a lakhs of records so far in a > normalized RDBMS tables, say Order, Item, Details etc. We are planning to > have a offline database (star schema) and develop reports, data analytical > charts with drill down, dashboard with data from offline database. > > I am planning to propose solr as a solution instead of a offline database > ie through DIH to import data from DB into solr indexes. Since Solr indexes > are stored denormalized manner and querying is faster, faceting search, i > assumed that solr can be used to solve my requirement. > > Please correct me if i am wrong. > > Thanks, > Pradeep > > > > > On Tue, Jun 25, 2013 at 3:43 AM, Otis Gospodnetic < > otis.gospodne...@gmail.com> wrote: > >> Yeah, perhaps.... yet people keep using it for this. So, Pradeep, it >> may work for you and if you share some numbers with us we may be able >> to tell you "no way" or "very likely OK". :) >> >> >> Otis >> -- >> Solr & ElasticSearch Support -- http://sematext.com/ >> Performance Monitoring -- http://sematext.com/spm >> >> >> >> On Mon, Jun 24, 2013 at 4:14 PM, Walter Underwood <wun...@wunderwood.org> >> wrote: >> > I expect it won't be fast enough for general use. Most analytics stores >> implement functions inside the server to aggregate large amounts of data. >> There is always some query that returns the whole database in order to >> calculate an average. >> > >> > I'm sure it will work fine for some things and for small data sets, but >> it probably won't scale for most real analytics applications. >> > >> > wunder >> > >> > On Jun 24, 2013, at 12:47 PM, pradeep kumar wrote: >> > >> >> Hello everyone, >> >> >> >> Apart from text search, can we use Solr as data store to serve data to >> form >> >> analytics with drilldown charts or charts to add as widgets on >> dashboards? >> >> >> >> Any suggestion, examples? >> >> >> >> Thanks, >> >> Pradeep >> > >> > >> > >> > >> > >