title: Is a MySQL view faster than a normal query?
body: <p>I have a complex query using many joins (8 in fact). I was thinking of simplifying it into a view. After a little research I can see the benefits in simplicity and security. But I didn't see any mentions of speed.</p>
  
  <p>Do views work like prepared statements, where the query is pre-compiled? Is there any notable performance gain from using views?</p>