You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by "Jason, Kim" <hi...@gmail.com> on 2011/07/04 07:48:01 UTC

how to improve query result time.

Hi All
I have complex phrase queries including wildcard.
(ex. q="conn* pho*"~2 OR "inter* pho*"~2 OR ...)
That takes long query result time.
I tried reindex after changing termIndexInterval to 8 for reduce the query
result time through more loading term index info.
I thought if I do so query result time will be faster.
But it wasn't.
I doubt searching for .frq/.prx spends more time...
Any ideas for impoving query result time?

I'm using Solr 1.4 and schema.xml is below.

<fieldType name="text" class="solr.TextField" positionIncrementGap="100">
    <analyzer type="index">
        <tokenizer class="solr.WhitespaceTokenizerFactory"/>
        <filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" enablePositionIncrements="true" />
        <filter class="solr.WordDelimiterFilterFactory"
generateWordParts="1" generateNumberParts="1" catenateWords="1"
catenateNumbers="1" catenateAll="1" splitOnCaseChange="1" />
        <filter class="solr.LowerCaseFilterFactory" />
        <filter class="solr.SnowballPorterWithUnstemFilterFactory"
language="English" protected="protwords.txt" />
    </analyzer>
    <analyzer type="query">
        <tokenizer class="solr.WhitespaceTokenizerFactory"/>
        <filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" enablePositionIncrements="true" />
        <filter class="solr.WordDelimiterFilterFactory"
generateWordParts="1" generateNumberParts="1" catenateWords="0"
catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
        <filter class="solr.LowerCaseFilterFactory" />
        <filter class="solr.SnowballPorterFilterFactory" language="English"
protected="protwords.txt" />
    </analyzer>
</fieldType>

Thanks in advance

--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-improve-query-result-time-tp3136554p3136554.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: how to improve query result time.

Posted by Dmitry Kan <dm...@gmail.com>.
how long is an average query?
I have noticed, that if the query with such a contents as you specified, it
can take a while to return the hits. How big is your index?

On Mon, Jul 4, 2011 at 8:48 AM, Jason, Kim <hi...@gmail.com> wrote:

> Hi All
> I have complex phrase queries including wildcard.
> (ex. q="conn* pho*"~2 OR "inter* pho*"~2 OR ...)
> That takes long query result time.
> I tried reindex after changing termIndexInterval to 8 for reduce the query
> result time through more loading term index info.
> I thought if I do so query result time will be faster.
> But it wasn't.
> I doubt searching for .frq/.prx spends more time...
> Any ideas for impoving query result time?
>
> I'm using Solr 1.4 and schema.xml is below.
>
> <fieldType name="text" class="solr.TextField" positionIncrementGap="100">
>    <analyzer type="index">
>        <tokenizer class="solr.WhitespaceTokenizerFactory"/>
>        <filter class="solr.StopFilterFactory" ignoreCase="true"
> words="stopwords.txt" enablePositionIncrements="true" />
>        <filter class="solr.WordDelimiterFilterFactory"
> generateWordParts="1" generateNumberParts="1" catenateWords="1"
> catenateNumbers="1" catenateAll="1" splitOnCaseChange="1" />
>        <filter class="solr.LowerCaseFilterFactory" />
>        <filter class="solr.SnowballPorterWithUnstemFilterFactory"
> language="English" protected="protwords.txt" />
>    </analyzer>
>    <analyzer type="query">
>        <tokenizer class="solr.WhitespaceTokenizerFactory"/>
>        <filter class="solr.StopFilterFactory" ignoreCase="true"
> words="stopwords.txt" enablePositionIncrements="true" />
>        <filter class="solr.WordDelimiterFilterFactory"
> generateWordParts="1" generateNumberParts="1" catenateWords="0"
> catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
>        <filter class="solr.LowerCaseFilterFactory" />
>        <filter class="solr.SnowballPorterFilterFactory" language="English"
> protected="protwords.txt" />
>    </analyzer>
> </fieldType>
>
> Thanks in advance
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/how-to-improve-query-result-time-tp3136554p3136554.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 
Regards,

Dmitry Kan