Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know if the usage of Views in Mysql (version 5.1.57) offers better performance than doing always the same query directly to the db?


share|improve this question

closed as off topic by gbn, Michael Hampton, voretaq7 Aug 3 '12 at 5:09

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 5 down vote accepted


A view is just a macro that expands into the full query.
A view doesn't offer any magical performance boost

share|improve this answer
Is what I thank. Thanks – enedebe Feb 14 '12 at 10:32

Not the answer you're looking for? Browse other questions tagged or ask your own question.