Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks!

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 professional server, networking, or related infrastructure administration within the scope defined in the FAQ. 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 closed questions here.

1 Answer

up vote 5 down vote accepted

No.

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.