performance of million documents search

[weiqi wang]

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

Re: performance of million documents search

[weiqi wang]

Hi Erick,

It's very useful.Thank you very much

2010/4/26 Erick Erickson 

> 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  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
> >
>