How not to store original Sphinx data?

Question

MySQL

Hello!
I want to build a Sphinx RT index over a MySQL table. For search / grouping / sorting, almost the entire table is duplicated. Does it make sense then to have two databases with identical data? Or is it possible to completely abandon MySQL and use the RT index? If not, is it possible to somehow exclude data storage in Sphinx? (store only the index) and extract only the id of the records on request and make a query to MySQL?
Thank you.

Answer 1

so you don’t put data in your mouth that you don’t need there, but only those that you are looking for

Answer 2

The original data must be stored, because the Sphinx stores data in its own format and with the loss of formatting, tags, etc. Its format is needed only for quick search. Extra fields (which will not be searched) can and should be removed from there. And by the found id, take the content in the database.