This is another type of issue, which we can address in another ticket.
But I can leave here some inputs related to large sites and how to solve the possible issues.
1. Views could be used for such a Search, but the database might not.
Views is a wrapper (or a GUI) for the native WordPress search, meaning WP_Query instances.
When you start adding filters, it becomes expensive because the database interaction is expensive by itself.
As example, WordPress stores ALL posts in a single Table.
On sites with lots of posts, custom fields and users (as example wp-types has a high number of these) it means a very expensive database interaction.
Views can handle for sure if your database can handle complex queries for lots of visitors.
Once you get to a point where WordPress WP_Query is not enough, then you need to head to database solutions, which is what we did on wp-types forums as example.
We do use our own parametric search in https://wpml.org/theme/ and https://wpml.org/plugin/, where we actually list very specific, limited Post Types, filtered by a very limited amount of Meta values.
Below some additional information on how you can decide whether Views fits your needs or not:
1. From what point on do we speak of “numerous content”?
300 posts + meta?
1000?
100000?
The number can not be fixed, it depends on your own server performance and load.
Also, on your settings. Just a few examples:
Do you have post revisions enabled?
Other plugins adding extra tables?
How many visitors (that could end up eating the available memory at once) will use this feature on the website?
It depends on many factors including also the Server and DDBB.
If you plan to build a website where several users will query the DDBB with Views simultaneously, and you got several Content types and entries, Views might not be the correct Tool, mainly due to the fact, that WordPress itself can not provide the correct DDBB Structure for it, and we do not want to unfollow best practices and begin to add Custom tables to the DDBB.
But we also have a DOC for performance issues:
https://toolset.com/documentation/user-guides/front-page-filters/how-to-use-views-parametric-search-on-large-sites/