Hello, I am Looking into trigger point for sharding Indexes based on response time ,and would like to define an acceptable response time.
Given a 3GB index ,when Can i think of sharding .The response times being variable based on the query and varies from 100ms to 600ms .We are running solr 1.3 with a collapse path for this instance. A simple query gets a quick response ,however a complex Boolean query with collapse takes a longer time .Should we base the acceptable time base on the most complex or simple queries or somewhere in between. Does sharding work with a collapse patch? Any pointer on an acceptable response time definition and at what point we can think of sharding based on the response time? Regards Sujatha