I use elastic search on 15 million records - 64gb ram and it performs great. The index doesn't need so much ram though. If it's too hard to set up, then go with the hosted version or you can check out algolia but it can get crazy expensive but might be worth it depending on your business model.
|