Hello,

I used the terms request for autocomplete. It works fine with 200.000
records but with 2 million docs it's very slow..

I use some regex to fix autocomplete in the middle of words, example: chest
-> manchester.

My call(pecl PHP solr):

$query = new SolrQuery();
$query->setTermsLimit("10");
       
$query->setTerms(true);
$query->setTermsField($field);
       
$term = SolrUtils::escapeQueryChars ($term);
$query->set("terms.regex","(.*)$term(.*)");
$query->set("terms.regex.flag","case_insensitive");

URL:
/solr/terms?terms.fl=autocompletewhat&terms.regex=(.*)chest(.*)&terms.regex.flag=case_insensitive&terms=true

I think the regex is the reason for the very high query time: Solr search
between 2 million docs with a regex. The query takes 2 seconds, this is to
much for the autocomplete. A user typed "manchester united" and solr needs
to do 16 query's from 2 seconds. Are there some other options? Faster
solutions?

I use solr 3.1 

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Slow-autocomplete-terms-tp3351352p3351352.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to