Does a large number of views in MySQL affect database performance?

Question

MySQL

How does the creation of a large number of views in the database (about 100,000 - 1,000,000) affect performance?
Those. Let's say there is one large table, and thousands of database users should have access to it only through their views (for security purposes). How much will this affect performance?

Answer 1

What does views have to do with security?

Answer 2

It will be related to performance read . There are no pluses. Access to view = subselect. And if the volume of the view is large, then it will be death in general.
If there is a desire to limit the user's access to data, then it is better to dig towards procedures and functions. It is possible to make query constructors on the side of the database server and return the result of the assembled query.