Re: performance of million documents search

2010-04-25 Thread 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
> >
>


Re: performance of million documents search

2010-04-25 Thread 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
>


performance of million documents search

2010-04-24 Thread 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