Why is sphinx slower than mysql fulltext?

Question

Sphinx

Hello, I am moving the site search to sphinxsearch, now it works on mysql fulltext.

Downloaded and installed the latest version of sphinxsearch from the official site.

I get terrible results in time (sphinxsearch is slower). Here I created a test environment for searching (it works on the same data set):
https://izap24.ru/sphinx/test.php

To search for results, you can search for car brands, for example "bmw e46".

Am I misconfiguring sphinx?

Answer 1

Am I misconfiguring sphinx?

How can we know? Did you show us the settings? Or described the server? Maybe you have them on different servers. Maybe you process the received data differently? Maybe you have a request of some kind of curve?

Answer 2

crookedly tuned or crookedly look for
the sphinx is always an order of magnitude two faster muscles in the search

Answer 3

In general, I put the same cron request and measured the time in ms for mysql and sphinx.
The results are unstable and mixed:
2020-07-13 00:00:07:242|5743
2020-07-13 01:00:09:1795|5827
2020-07-13 02:00:04:201|2086
2020- 07-13 03:00:04:119|3124
2020-07-13 04:00:06:2807|1685
2020-07-13 05:06:27:1153|384722
2020-07-13 06:00:05 :1114|2317
2020-07-13 07:00:07:2719|3121
2020-07-13 08:00:05:1699|2627
2020-07-13 09:00:17:1575|12711
2020-07- 13 10:00:03:115|1954
2020-07-13 11:00:06:1188|3142
2020-07-13 12:00:03:639|1922
2020-07-13 13:00:04:859 |2369
2020-07-13 14:00:05:1206|2813
2020-07-13 15:00:04:273|2263
2020-07-13 16:00:04:124|1901
2020-07-13 17:00:12:1305|
9818 :05:924|3223
2020-07-13 19:00:15:256|12140
2020-07-13 20:00:11:1674|2470
2020-07-13 21:00:02:500|1184
2020- 07-13 22:00:03: 63|1707
2020-07-13 23:00:04: 711|2129
Then rolled out a new engine to the site and lo and behold:
2020-07-16 00:00:04: 33|2362
2020-07-16 01:00:03:77|2029 2020-07-16 02:00:
04:64|2280
2020-07-16 03:00:03:21|2091
:03:22|1555
2020-07-16 05:05:52:71|350448
2020-07-16 06:00:06:85|4421
2020-07-16 07:00:03:72|2492
2020- 07-16 08:00:07:72|5772
2020-07-16 09:00:04:69|2436
2020-07-16 10:00:03:32|1510 2020-07-16 11:00:
03:23|2007
:04:54|1902
2020-07-16 13:00:03:71|2213
2020-07-16 14:00:03:31|2423
2020-07-16 15:00:03:72|1581
2020- 07-16 16:00:04:24|2300
2020-07-16 17:00:07:41|6524
2020-07-16 18:00:03:38|1935
2020-07-16 19:00:03 : 60|2060
2020-07-16 20:00:03:32|1891
2020-07-16 21:00:03:22|2277
2020-07-16 22:00:04:22|2355
2020-07- 16 23:00:03:33|2003
Apparently the engine itself must also be warmed up for good work)