Does it make sense to use Sphinx for full text search?

Question

PostgreSQL

PostgreSQL 10.6 and Symfony 4 are available.
There is some kind of CRM, where a large number of tables appear, the fields of which are used for full-text search. So far, this search is implemented in a primitive way - I use LIKE . I specify in the where() argument the fields by which the search is required. In the case of a large number of data, the search starts to slow down.
How efficient is it to use the Sphinx search engine with Symfony 4?

Answer 1

In the case of a large number of data, the search starts to slow down.

If this is the only problem with searching, then it is better to use Postgresql's built-in Full-Text Index. It doesn't require the hell of a cost to set up and integrate sphinxsearch into the project.

Answer 2

Why is the search slow?
Maybe the search itself does not work for a long time, but the subsequent sorting is already slow
Well, or fetching, if you send everything found to the client)
Reminded an interesting perversion - ZomboDB brings powerful text-search and analytics features to Postgres by using Elasticsearch as an index type

Answer 3

Postgres has its own full-text search and use it