A
A
Alexander2017-12-17 13:16:12
MySQL
Alexander, 2017-12-17 13:16:12

Why doesn't Sphinx display all matches?

I set up a Sphinx search in conjunction with CMS Moguta, the search is carried out according to the goods
Example of an error in the search: I write "Generator" in the line, it displays generators and generator belts, but not all generators are shown, if you narrow the search by specifying, for example, an engine model, for example " Generator H4M", the desired generator is shown.
Part of the config below:

source product: s_DB
{    
    sql_query_pre = SET NAMES UTF8
    sql_query = SELECT p.id, p.title, pv.title_variant, p.code, pv.code, p.code_tsb, p.url as codevariant, p.meta_title, p.description, p.meta_desc, p.meta_keywords FROM `mg_product` as p\
                LEFT JOIN `mg_product_variant` pv\
                     ON p.id = pv.product_id
}
index product 
{
    source = product 
    path = /usr/local/sphinx/var/data/product
    ondisk_attrs=1
    morphology = stem_en, stem_ru
    charset_table = 0..9, A..Z->a..z, _, a..z, \
    U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+451, U+451
    dict = keywords
    min_word_len= 2
  min_infix_len = 2
    min_prefix_len = 0
    html_strip = 0
  expand_keywords = 1
    index_exact_words = 1
  wordforms = /etc/sphinx/models.txt
  ignore_chars = U+AD
  
}

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dimonchik, 2017-12-17
@fdaemon

"not all" within max results , throw out the belts - will show everything
within max results

P
Puma Thailand, 2017-12-17
@opium

Tried to look at the second page of the search.?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question