A
A
Arman2018-11-09 14:29:20
Sphinx
Arman, 2018-11-09 14:29:20

What are the recommendations for sphinx?

DD. I know that he is very smart, but I decided to clarify just in case ... maybe someone already has experience.
At the moment, the default config + cut out the markup through sphinxsearch.com/docs/current/conf-html-strip.html
1. Does it make sense to combine all the fields that are searched, but not filtered?
those. instead of:

SELECT  `id`, `text-1`, `text-2`, `text-3`, `text-4`, `text-5` FROM...

do something like:
SELECT  `id`, CONCAT(`text-1`, ' ', `text-2`, ' ', `text-3`, ' ', `text-4`, ' ', `text-5` FROM...

2. Suppose there is a position field and on the result page we show "position desc" in reverse order,
does it make sense to immediately give the sphinx in the right order?
SELECT ... FROM ... WHERE ... ORDER BY position desc

3. I've seen many people add compression
mysql_connect_flags = 32 # enable compression
when should I use this flag?
If there are any other recommendations, I will be glad to read.
Interested in optimization both in search and indexing

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2018-11-09
@Arik

No
Yes
If the muscle is far away

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question