I have very big data in on table (more then 4lc rows). Right now i am using mysql full text search but its very slow. I google and found many blog which suggest to use elastic search for searching. We are testing if elastic search will help in fast search. but we are getting opposite result(mysql …

How to do full text search in elasticsearch

Ashwani_Kumar (Ashwani Kumar) April 5, 2016, 11:04am 5

can you Please share link from where i can refer.

Basically i need to do full text searching on one field
and other searching %oogl% ( mysql LIKE %oogle%)

Topic		Replies	Views
Full text searching performance (compare to mysql) Elasticsearch	8	5359	July 5, 2017
Elasticsearch speed comparison issue with sql Elasticsearch	10	517	April 19, 2021
How to search text in a table containing 100M rows? Elasticsearch	4	1733	July 6, 2017
Elasticsearch vs MySQL for large data set using exact value searching Elasticsearch	1	704	July 10, 2018
Poor performance of "full text" searches Elasticsearch	5	1707	July 6, 2017