Hi, I have about 2 million documents in my index. I want to search them by a string field. Every document have this field such as 'LB681' .
The field is a dynamic Field which type is string. So, in solr/admin , I do search by using " PartNo_s:L* " which means started with L, I can get the result from 2 million documents less than 300 ms. But, when I use " PartNo_s:*B68* " which means included B68 to search, It take more than 2000 ms. It is too slow for me. Has anyone know that how can I get the result more faster? thank you very much
