Hi We have tried out various configurations settings to improvise the performance of the site which is majorly using Solr but still the response time remains about 4-5 reqs/sec. We also did some performance tests on Solr 1.4 but still there is a very minute improvement in performance. Currently we are using Solr 1.3.
So our last resort remains, improvising the queries. We are using SolrJ - CommonsHttpSolrServer We guys are trying to tune up Solr Queries being used in our project. Following sample query takes about 6 secs to execute under normal traffic. At peak hours this often increases to 10-15 secs. sitename:XYZ OR sitename:"All Sites") AND (localeid:1237400589415) AND ((assettype:Gallery)) AND (rbcategory:"ABC XYZ" ) AND (startdate:[* TO 2009-12-07T23:59:00Z] AND enddate:[2009-12-07T00:00:00Z TO *])&rows=9&start=63&sort=date desc&facet=true&facet.field=assettype&facet.mincount=1 Similar to this query we have several much complex queries supporting all major landing pages of our application. Just want to confirm that whether anyone can identify any major flaws or issues in the sample query? Thanks Dipti
