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
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
July 9th 19 at 11:29
It is difficult to answer the question without any data.
The maximum that we can recommend now is to get acquainted with

Find more questions by tags MySQL