[anonu]

What would be your go-to solution for a basic word search - lets say you only have a few MBs of data - not GBs...

[rebelde]

Full-text search from MySQL or other similar database. When that gets overloaded, then consider something like Elastic Search. That is my rule.

[winrid]

Few mbs - just use lucene in memory if you're using Java.