Re: debugging solr query

2016-05-27 Thread Jay Potharaju
Thanks for the suggestion. At this time I wont be able to change any code in the API ...my options are limited to changing things at the solr level. Any suggestions regarding solr settings in config or schema changes are something in my control. On Fri, May 27, 2016 at 7:03 AM, Ahmet Arslan wro

Re: debugging solr query

2016-05-27 Thread Ahmet Arslan
Hi Jay, Please separate the clauses. Feed one of them to the main q parameter with content score operator =^ since you are sorting on a structured field(e.g. date) q:fieldB:(123 OR 456)^=1.0 &fq=dt1:[date1 TO *] &fq=dt2:[* TO NOW/DAY+1] &fq=fieldA:abc &sort=dt1 asc,field2 asc, fieldC desc Play

Re: debugging solr query

2016-05-27 Thread Jay Potharaju
I updated almost 1/3 of the data and ran my queries with new columns as mentioned earlier. The query returns data in almost half the time as compared to before. I am thinking that if I update all the columns there would not be much difference in query response time. Are there any suggestion

Re: debugging solr query

2016-05-26 Thread Jay Potharaju
Hi, Thanks for the feedback. The queries I run are very basic filter queries with some sorting. q:*:*&fq=(dt1:[date1 TO *] && dt2:[* TO NOW/DAY+1]) && fieldA:abc && fieldB:(123 OR 456)&sort=dt1 asc,field2 asc, fieldC desc I noticed that the date fields(dt1,dt2) are using date instead of tdate fie

Re: debugging solr query

2016-05-25 Thread Jay Potharaju
Any links that illustrate and talk about solr internals and how indexing/querying works would be a great help. Thanks Jay On Wed, May 25, 2016 at 6:30 PM, Jay Potharaju wrote: > Hi, > Thanks for the feedback. The queries I run are very basic filter queries > with some sorting. > > q:*:*&fq=(dt1:

Re: debugging solr query

2016-05-25 Thread Jay Potharaju
Hi, Thanks for the feedback. The queries I run are very basic filter queries with some sorting. q:*:*&fq=(dt1:[date1 TO *] && dt2:[* TO NOW/DAY+1]) && fieldA:abc && fieldB:(123 OR 456)&sort=dt1 asc,field2 asc, fieldC desc I noticed that the date fields(dt1,dt2) are using date instead of tdate fie

Re: debugging solr query

2016-05-24 Thread Erick Erickson
Try adding debug=timing, that'll give you an idea of what component is taking all the time. >From there, it's "more art than science". But you haven't given us much to go on. What is the query? Are you grouping? Faceting on high-cardinality fields? Returning 10,000 rows? Best, Erick On Tue, May

Re: debugging solr query

2016-05-24 Thread Ahmet Arslan
Hi, Is it QueryComponent taking time? Ot other components? Also make sure there is plenty of RAM for OS cache. Ahmet On Wednesday, May 25, 2016 1:47 AM, Jay Potharaju wrote: Hi, I am trying to debug solr performance problems on an old version of solr, 4.3.1. The queries are taking really

debugging solr query

2016-05-24 Thread Jay Potharaju
Hi, I am trying to debug solr performance problems on an old version of solr, 4.3.1. The queries are taking really long -in the range of 2-5 seconds!!. Running filter query with only one condition also takes about a second. There is memory available on the box for solr to use. I have been looking