MySQL search engine or ElasticSearch engine, which one to use ?
Some say that if you can't properly index your DB for ES and/or can't make proper queries, then there is no advantage.
Btw, the answer from chatgtp:
Elasticsearch and MySQL are both popular search engines, but they are designed to serve different purposes. Elasticsearch is a distributed search and analytics engine that is optimized for handling large volumes of unstructured data, while MySQL is a relational database management system that is optimized for handling structured data.
When it comes to full-text search, Elasticsearch has several advantages over MySQL. Here are some key differences between the two:
Text search capabilities: Elasticsearch is designed specifically for full-text search, and it has a rich set of features for indexing and searching text data. For example, Elasticsearch supports stemming, synonym expansion, and fuzzy matching, which can help to improve the accuracy of search results. In contrast, MySQL's full-text search capabilities are more limited, and it does not support some of the more advanced search features that Elasticsearch does.
Speed: Elasticsearch is generally faster than MySQL when it comes to full-text search, especially for large datasets. This is because Elasticsearch is optimized for search, whereas MySQL is optimized for transactional processing. Elasticsearch uses inverted indices and other techniques to speed up search queries, while MySQL relies on traditional indexing methods.
Scalability: Elasticsearch is highly scalable, and it is designed to handle large volumes of data across multiple nodes in a cluster. MySQL can also be scaled horizontally by adding more nodes, but it is not as well-suited for handling large amounts of unstructured data.
Ease of use: Elasticsearch has a relatively steep learning curve, and it requires a good understanding of the underlying technology in order to use it effectively. MySQL, on the other hand, is more user-friendly and has a more intuitive interface.
In summary, if you are working with unstructured data and need to perform complex text searches, Elasticsearch is likely to be a better choice than MySQL. However, if you are working with structured data and need to perform transactional processing, MySQL may be a more appropriate option.