How to organize Sphinx search for ads with nested categories?

Question

Sphinx

Greetings!
There is a table with ads , each has its category in category_id + its name in name + its additional info in info .
There is a table with categories , each has a parent category in parent_id ( they are nested ) + its name in name

As I understand it, it is possible to form a string from categories ala "real estate / apartments / 1km" and give it to the sphinx for indexing, but the question is how to generate it for each ad?

Answer 1

Options
1. set up the sphinx on xmlpipe, generating the necessary data
in a puff 2. make a storage in the DBMS and pull it from the sphinx
3. change the structure of the database and store for each category the entire path to the root category