3 ms·

Building over a full text search engine that indexes your db is going to scale much better in the long run. Plus you get stemming and other niceties to boot as

by sureshv 14y ago

Building over a full text search engine that indexes your db is going to scale much better in the long run. Plus you get stemming and other niceties to boot as long as consistency is not of the highest priority.

r00fus 14y ago
With tools like SOLR or Elasticsearch, I keep wondering why people try to re-invent the full-text indexing wheel - these tools make it easy to focus your app/datastore on your functionality and leave search as an additional service, to be used whenever you need it.