PavelJ:

"I tried to find out how is this possible and the result was clear, based on both DBMS docs - very poor implementation of views in mysql. Most of complex queries fall into 'temptable' type, which means that temporary table is created every time query is executed."

How, in $DEITY's name, can anyone work with such an sad excuse of a DBMS?