What release of Solr are you on? Solr 4.0 has improved wildcard support (FST
"automatons".) But even then, such heavy use of wildcards may be
problematic.
If you intend to use wildcard in that manner, you might want to create a
customer stemming filter that does that stemming at index time (and query
time) so you don't need to do such heavy wildcarding.
Do these complex queries always run slow (the first time each is tried) or
just sometimes or some of the queries? (Solr will cache the results of a
given query so that the next time the same results can be returned without
re-querying the index.)
-- Jack Krupansky
-----Original Message-----
From: Jason
Sent: Monday, October 08, 2012 12:26 AM
To: solr-user@lucene.apache.org
Subject: Re: long query response time in shards search
Hi, Otis
Thanks your reply.
yes, all cores are in same server.
* what do you consider "too long"?
just id(key) query response takes too long.
almost id(key) query response takes under 10ms.
example
---------------------
2012-10-05 16:38:32,078 [http-8080-exec-3979] INFO
org.apache.solr.core.SolrCore - [usp00] webapp=/solr_us path=/select
params={rows=1&shards=usp00,usp01,usp02,usp03,usp04,usp05&fl=cin,score&start=0&q=id:(US2008000040881A1)}
status=0 QTime=164085
* how many queries are running concurrently?
approximately 5 to 10 queries.
but queries are very complex. complex means many terms include wildcard.
* can you show some example queries?
example
---------------------
q=(angiogenesis*+OR+neovascula*+OR+(vessel*+OR+vascula*)+N+(proliferat*+OR+growth*))+5N+(inhibit*+OR+prevent*+OR+treat*+OR+thera*+OR+medic*)+AND+(ibd+OR+crohn*+OR+behcet*+OR+inflammat*+2N+(bowel*+OR+intestin*+OR+colitis*+OR+enteritis*+OR+gastroenteritis*)+OR+ulcerative*+W+colitis*+OR+intestin*+W+behcet*+OR+macula*+W+degenerat*+OR+amd+OR+armd)
* how many CPU cores does your server have?
32 cores (server has 4 CPU and 8 cores in each CPU.)
128G RAM
Also, total index for all cores include 15million docs and size is 400G.
complex queries are problem??
--
View this message in context:
http://lucene.472066.n3.nabble.com/long-query-response-time-in-shards-search-tp4012366p4012378.html
Sent from the Solr - User mailing list archive at Nabble.com.
