Hi all, I have been experimenting solr faceted search for 2 weeks. But I meet performance limitation on facet Search. My solr contains 4,000,000 documents. Normal searching is fairly fast, But faceted search is extremely slow.
I am trying to do facet search on 3 fields (all multivalued fields) in one query. field1 has 2 million distinct values, field2 has 1.5 million distinct values, field3 has 50,000 distinct values. I already set the filterCache to 3,000,000, But the searching speed is still very slow. Normally each query will took 5 mins or more. As I narrow down the search, the speed will increase dramatically. Is there anyway to optimize the faceted search? Every help is appreciated. Thanks in advanced. Regards GC
