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
