HI, i have indexed a data (commands from files) with 10 fields and 3 of them is text fields. collection is created with 3 shards and 2 replicas. I have used document routing as well.
Currently collection holds 47,80,01,405 records. text search against text field taking around 5 sec. solr is query just and of two terms with fl as 7 fields fileId:"file unique id" AND command_text:(system login) (each file has number of commands, use case : search command in a file). Adding shard.keys in the query improved the query response to some extent. but still the query is slow. Please let me know if you have any suggestions to improve the query performance. Thanks for your help. Thanks, Anil
