Hey y'all, I've an Oracle table with a lot of random text in each record. It has a total of 5M records and it's growing around ~500k a year. I need to make the search faster which looks for an input string from users into all the records. What's the best way to implement a search which can look through the entire table in a matter of a few seconds? TC: 250k
Elasticsearch