Question: do mysql views improve performance?
Answer: How do MySQL views improve the performance of an EAV model database? ... Anything you can do with a view can be done with a "direct" query, so while views may make your schema easier to handle by reducing app-side query text, they won't make the database run any faster.