this is how my 'time' field looks in schema : <field name="time" type="tint" indexed="true" stored="false"/>
and also, I am doing frequent Update to Solr (every 5 minuts). On 22 June 2011 18:41, Ahmet Arslan <iori...@yahoo.com> wrote: > > I am running two solrShards. I have > > indexed 100 million docs in each shard ( > > each are 50 GB and only 'id' is stored). > > My search have became very slow. Its taking around 2-3 > > seconds. > > below is my query : > > > > > http://solrHost1:8080/solr/select?shards=solrHost1:8080/solr,solrHost2:8080/solr&q= > > QUERY&fq=FilterQuery&fl=id&start=0&rows=100&indent=on&sort=time > > desc > > > > QUERY and FilterQuery is below : > > > > QUERY = Online Shopping AND ( Amex OR Am ex OR American > > express OR > > americanexpress ) > > FilterQuery = time:[1308659371 TO 1308745771] AND > > category:news AND > > lang:English > > > > How to boost the query perfomance. > > default search filed is title( text). > > If fieldType of time is not trie-based, you can change it to tdate, tint > etc. For range queries. > > If you don't update your index frequently, you can use separate filter > queries (fq) for your clauses. To benefit from caching. > &fq=category:news&fq=lang:English > > http://wiki.apache.org/solr/SolrPerformanceFactors > http://wiki.apache.org/lucene-java/ImproveSearchingSpeed > -- Thanks and Regards Mohammad Shariq
