Mark - there’s more to the equation than your query, I imagine. Are you
returning a larger number of rows or facets?
Can you share the Solr log of that request (and perhaps any request handler
config if you’ve adjusted that)?
Erik
> On Mar 3, 2016, at 4:21 AM, Mark Robinson <mark123lea...@gmail.com> wrote:
>
> Hi,
> I am running the following query on an index that has around 123 million
> records, using SolrJ..
> Each record has only 5 fields.
>
> String *qry*="( fieldA:(value1 OR value2 OR .... value24) AND
> fieldB:(value1 OR value2 OR value3 OR value4 OR value5) )
> (...basically a simple AND of 2 ORs)
>
> When I hit directly from browser QTime is in the range of 300 - 400 milli
> secs max.
>
> But when I run through SolrJ my (endtime - starttime) gives 20 seconds max
> (when run on a machine with 16 CPUs and 60GB RAM with heap size 25G
> allocated).
> When run on my laptop which has only 4GB RAM the SolrJ (endtime -
> starttime) gives 60s to a maximum of 90s sometimes.
>
> Why could this huge difference in timing be when queried using SolrJ.
>
> Also could you please suggest on how I can get the timing close to the
> timing I see when I hit the index directly from browser.
> Note:- All programs (java as well as SOLR) reside on the same machine in
> both cases (more powerful machine as well as laptop) when I tried.
>
> When I tried with the more powerful machine I even gave firstSearcher
> q=*:*, but no impact was seen.
>
> I am looking for good response times from my first query itself. So I did
> not explore much on caching.
>
> Any help is greatly appreciated.
>
> Thanks!
> Mark
