Is there any knowledge on this list about the performance crossover between a single index and sharding and when to change from a single index to sharding?
E.g. if index size is larger than 150GB and num of docs is more than 25 mio. then it is better to change from single index to sharding and have two shards. Or something like this... Sure, solr might even handle 50 mio. docs but performance is going down and a sharded system with distributed search will be faster than a single index, or not? Is a single index always fast than sharding? Regards Bernd