Hi Wael, Can you provide your field definition and sample query. Thanks, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/
> On 6 Nov 2017, at 08:30, Wael Kader <w...@softech-lb.com> wrote: > > Hello, > > I am having an index with around 100 Million documents. > I have a multivalued column that I am saving big chunks of text data in. It > has around 20 GB of RAM and 4 CPU's. > > I was doing faceting on it to get word cloud but it was taking around 1 > second to retrieve when the data was 5-10 Million . > Now I have more data and its taking minutes to get the results (that is if > it gets it and SOLR doesn't crash). Whats the best way to make it run or > maybe its not scalable to make it run on my current schema and design with > News articles. > > I am looking to find the best solution for this. Maybe create another index > to split the data while inserting it or maybe if I change some settings in > SolrConfig or add some RAM, it would perform better. > > -- > Regards, > Wael