Questions about SphinxSearch configuration source

several questions about source configuration. Assume that the configured source has the following

sql_query = \
    SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, \
        title, content \
    FROM documents

1) all non-full-text search fields after select must correspond to sql_attr_xxx = field_name ?
2) with regard to sql_attr_string, if it is written that this field will not be indexed, it will be saved, then this use is
3) is the index table structure self-defined sql_attr_string or sql_field_string

Jun.30,2022

official document: http://sphinxsearch.com/docs/...
sql_attr_ is to reduce the number of times to query the database after the index data is queried, and to obtain data directly from sphinx. Sql_field_ data is indexed.
whether all non-full-text search fields are used sql_attr_xxx = field_name look at your business scenario and your tradeoff between sphinx memory and mysql queries. Generally, only frequently queried fields are put in

Menu