The problem isn't with the default XF search, it's mainly down to constraints within MySql search, hence the reason why Elastic search works better with larger forums than the standard MySql search.
From what I understand with ES you are not searching the database directly but searching an index of the database, the index is updated by ES periodically.
(please correct me if I'm wrong
)