I certainly recommend testing this to see what kind of response times
you get for the first and successive searches after the caches are
built - be sure to use the same IndexReader for all searches to
benefit from caching :)
Sorting on 4-5 columns seems kind of extreme. Sorting uses up RAM
with the caches, so it would surely be much more efficient to
collapse the fields you need to sort by into a single field if
possible, and try to do so numerically rather than as Strings.
Erik
On 4 Nov 2005, at 02:35, Manoj Kr. Sheoran wrote:
> Hi Chris,
> Thanks for sharing your views with us. Is sorting works properly.
> Is there
> any idea regarding time estimation for sort on 4-5 columns with 1
> million
> records?
>
> Regards,
> Manoj
> ----- Original Message -----
> From: "Chris Lu" <chris.lu@gmail.com>
> To: <java-user@lucene.apache.org>
> Sent: Friday, November 04, 2005 12:30 PM
> Subject: Re: Searching the contents
>
>
>
>> One of my case is using PIII 450MHz 256M RAM, with 1million records,
>> the search is around 3~4 seconds for the very first search, and
>> sub-second, usually under 0.5 second.
>>
>> Sorting on one column will be longer, like 7~8 seconds for the first
>> sort. And subseconds with cache.
>>
>> Chris Lu
>> ---------------------------
>> Full-Text Search on Any Database
>> http://www.dbsight.net
>>
>> On 11/3/05, Manoj Kr. Sheoran <manoj.kumar@daffodildb.com> wrote:
>>
>>> Hi,
>>> I am having 1,00,000 documents in a index but in near future it
>>> will be
>>>
> 3 million and more. I am somewhat concerned about the searhing
> process
> with this much number of document. I am giving order on some
> fields of
> documents. Could anybody tell be the expected result from lucene
> engine with
> 3 million results and order/sorted on 4 column.
>
>>>
>>> Thanks,
>>> Manoj
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
>> For additional commands, e-mail: java-user-help@lucene.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
|