I want to use full text search in my project... Can anyone explain me, what is the difference between ElasticSearch and SQL Full Text Search
Or
why SQL Full Text Search is better (worse) than elastic?
documentations, presentations, schema...
2 Answers
The answer depends on what goal you're trying to achieve and what resources you have to reach it. SQL server fulltext search is lower admin but limited in functionalities. Elastic search is at the other end of the spectrum.
SQL server fulltext search:
- can prove efficient if you're data is not considerable growing and or schema is not changing over time
- requires less effort to maintain and less of a learning curve/need for new competence
Elasticsearch:
- need for data ingestion if your master db is having frequent incremental updates (logstash and other alternatives)
- scales better horizontally
- ability to use advanced features to improve performance for very large data sets (eg. routing)
Related