The query without load is still under 1 second. But under load, response time can be much longer due to the queued up query.
We would like to shard the data to something like 6 M / shard, which will still give a under 1 second response time under load. What are some best practice to shard the data? for example, we could shard the data by date range, but that is pretty dynamic, and we could shard data by some other properties, but if the data is not evenly distributed, you may not be able shard it anymore. -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-do-a-Data-sharding-for-data-in-a-database-table-tp4212765p4212803.html Sent from the Solr - User mailing list archive at Nabble.com.
