lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <e...@ehatchersolutions.com>
Subject Re: Performance stats for indeces with over 10MM documents
Date Thu, 03 Jan 2008 02:05:30 GMT
Are you faceting?

Please provide the exact lines logged in Solr's console for the  
offending queries - that would show us _exactly_ what you're hitting  
Solr with, not just the q parameter as you seem to have provided.

	Erik


On Jan 2, 2008, at 8:47 PM, Alex Benjamen wrote:

> JDS:
>
>> That's too slow.  Can you provide more details about your schema,  
>> queries etc?
>
> Ofcourse - I'm using the standard config which comes with solr, and  
> I've added
> the following fields :
>
>   <field name="id" type="integer" indexed="true" stored="true"  
> required="true" />
>    <field name="status" type="text" indexed="true" stored="false"/>
>    <field name="seeking" type="text" indexed="true" stored="false"/>
>    <field name="gender" type="text" indexed="true" stored="false"/>
>    <field name="orientation" type="text" indexed="true"  
> stored="false"/>
>    <field name="interests" type="text" indexed="true" stored="false"/>
>    <field name="relationship" type="text" indexed="true"  
> stored="false"/>
>    <field name="dating" type="text" indexed="true" stored="false"/>
>    <field name="friends" type="text" indexed="true" stored="false"/>
>    <field name="activity" type="text" indexed="true" stored="false"/>
>    <field name="age" type="sint" indexed="true" stored="true"/>
>    <field name="country" type="text" indexed="true" stored="false"/>
>    <field name="zipcode" type="text" indexed="true" stored="false"/>
>    <field name="postalcode" type="text" indexed="true"  
> stored="false"/>
>    <field name="state" type="text" indexed="true" stored="false"/>
>    <field name="province" type="text" indexed="true" stored="false"/>
>    <field name="city" type="text" indexed="true" stored="false"/>
>    <field name="fbooks" type="text" indexed="true" stored="false"/>
>    <field name="fmovies" type="text" indexed="true" stored="false"/>
>    <field name="fmusic" type="text" indexed="true" stored="false"/>
>    <field name="ftv" type="text" indexed="true" stored="false"/>
>    <field name="school" type="text" indexed="true" stored="false"/>
>    <field name="hometown" type="text" indexed="true" stored="false"/>
>    <field name="lastlogin_months" type="sint" indexed="true"  
> stored="false"/>
>    <field name="locationString" type="text" indexed="true"  
> stored="false"/>
>    <field name="affiliations" type="text" indexed="true"  
> stored="false"/>
>    <field name="companies" type="text" indexed="true" stored="false"/>
>    <field name="photos" type="text" indexed="true" stored="false"/>
>
>
> A typical query looks something like this:
>
> gender:m AND status:(2 || 8 || 6 || 3) AND age:(26 || 27 || 28 ||  
> 29) AND orientation:3
> gender:f AND age:(27 || 28 || 29 || 30 || 31 || 32 || 33 || 34 ||  
> 35 || 36 ) AND orientation:2 AND photos:y
> gender:f AND (activity:y) AND age:(28 || 29 || 30 || 31 || 32 ||  
> 33 ) AND orientation:2
>
> Thanks
> -Alex
>
>
>
>
>


Mime
View raw message