Sujatha - that query debug output shows only 218ms, so it isn't
representative of the issue you're reporting.
Also, what's the query parse output? I imagine you're doing a boolean
OR query across all those terms (include "a"), yes? Maybe you'd rather
the
operator be AND?
Erik
On Aug 17, 2012, at 08:01 , Sujatha Arun wrote:
> No customization,its the default standard request handler.Solr Version
is
> 1.3
>
> "a" is not there in stop words
>
> Server Load ,i presume is not there , but not too sure ,not checked.
>
> RAM :
>
> TOTAL RAM :48GB
> RAM to JVM :18 GB ,Permgen =2GB
> TOTAL INDEX SIZE of all the multicore Instances =23GB
>
> Timing [Cut & paste ] , I have never looked at this before
>
> <str name="QParser">OldLuceneQParser</str><lst name="timing"><double
> name="time">218.0</double><lst name="prepare"><double
> name="time">6.0</double><lst
> name="org.apache.solr.handler.component.QueryComponent"><double
> name="time">5.0</double></lst><lst
> name="org.apache.solr.handler.component.FacetComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.MoreLikeThisComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.HighlightComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.DebugComponent"><double
> name="time">0.0</double></lst></lst><lst name="process"><double
> name="time">211.0</double><lst
> name="org.apache.solr.handler.component.QueryComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.FacetComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.MoreLikeThisComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.HighlightComponent"><double
> name="time">0.0</double></lst><lst
> name="org.apache.solr.handler.component.DebugComponent"><double
> name="time">211.0</double></lst></lst></lst></lst>
>
> Regards
> Sujatha
>
> On Fri, Aug 17, 2012 at 4:11 PM, Erik Hatcher <erik.hatc...@gmail.com
>wrote:
>
>> 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
>>>>
>>>>
>>
>>
