Hi, To calculate some stats we are using a field "B" with 50.000.0000 different values as facet pivot in a schema that contains 200.000.000 documents. We only need to calculate how many different "B" values have more than 1 document but it takes ages.... Is there any other better way/configuration to do this?
Configuration: Solr 4.2.1 JVM Java 7 Max Java Heap size : 12Gb 8 GB RAM Dual Core Many thanks.