NGrams might help here, search the SOLR list for "NGram" and I think you'll find that this subject has been discussed several times...
HTH Erick On Sat, Apr 24, 2010 at 9:26 PM, weiqi wang <weiqi...@gmail.com> wrote: > 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 >
