Just over 4M docs... no need to shard.
Both your queries contain what is likely very common terms (content:a in the
first one and content:1 in the second). Generally these are "stop words" and
removed either during indexing or querying, but I guess not in your case.
What's your "standard" request handler look like? Doing anything custom in
there?
What are the timings of the components in the debugQuery=true response?
Is the server under load when you're issuing these queries? What about RAM?
Again, what version of Solr?
Erik
On Aug 17, 2012, at 06:35 , Sujatha Arun wrote:
> Hi Erick,
>
> The number of documents is : 4389048
>
> I have given 2 queries below with timing and the number of hits
>
> INFO: [ipc_widget_search] webapp=/multicore_5 path=/select/
> params={version=2.1&fl=*+score&stylesheet=&qt=standard&fq=&rows=100&start=0&q=content:if+content:elena+content:reads+content:at+content:a+content:rate+content:of+content:r+content:pages+content:per+content:minute+content:for+content:a+content:total+content:of+content:m+content:minutes}
> hits=3331109 status=0 QTime=22677
>
> INFO: [ipc_widget_search] webapp=/multicore_5 path=/select/
> params={version=2.1&fl=*+score&stylesheet=&qt=standard&fq=&rows=100&start=0&q=content:chapter+content:1}
> hits=1919445 status=0 QTime=6677
>
>
> Any time I execute the time taken to execute the first query is > than
> 22secs ,now it took 33 secs to execute.
>
> Regards
> Sujatha
>
>
> On Fri, Aug 17, 2012 at 3:30 PM, Erik Hatcher <erik.hatc...@gmail.com>wrote:
>
>> How many documents do you have? What are the queries? I'd guess your
>> query complexity (or load) is to blame here, not index size. What version
>> of Solr?
>>
>> Until you know what is causing the slow queries, sharding is not something
>> to consider I'd say. But yes, you would want to reindex to distribute the
>> documents.
>>
>> Erik
>>
>>
>> On Aug 17, 2012, at 02:21 , Sujatha Arun wrote:
>>
>>> Hello,
>>>
>>> One of the Index in a multicore set up has a 3GB+ index ,and it seems to
>>> take around 5000ms+ to return simple boolean queries . The Index is
>>> not optimized
>>> Would it make sense to shard the index as cores in the same server to
>>> expect better response time?
>>>
>>> do I have to re index all over again to distribute the documents between
>> 2
>>> shards ?
>>>
>>> Regards
>>> Sujatha
>>
>>
