How to improve performance of the query with the join view?

Good afternoon.
There is a problem, individually selects are fast 0.060 seconds, when you join tables with a view is performed 10 seconds, the question is how to speed up the join view?
July 9th 19 at 11:25
2 answers
July 9th 19 at 11:27
Solution
Classic view in mysql are not cached. Ie, each time you request re-built the whole view, and he (without any indexes) is the join, which of course is very slow.
Solutions 2:
a) rewrite without view and without virtual tables ;-)
b) use the crutch of view www.fromdual.com/mysql-materialized-views
July 9th 19 at 11:29
Solution
It is difficult to answer the question without any data.
The maximum that we can recommend now is to get acquainted with ruseller.com/lessons.php?id=692

Find more questions by tags MySQL