We have some slow mysql queries. One is caused by including queries from views.
Here the log info:
SELECT min(price) AS price_min, max(price) AS price_max FROM categories_price;
# Time: 130710 7:51:55
# User@Host: xxxxxx[xxxx] @ localhost 
# Query_time: 7.922020 Lock_time: 0.000157 Rows_sent: 1 Rows_examined: 14029050
The categories_price [2700 records] view combines an other view called products_price [2480 records].
I have try the 3 ALGORITHM; TEMPTABLE - MERGE - UNDEFINIED without success.
The others are only not correct coded queries that slows the result.
The code is written for our web-shops.
We need a professional MYSQL coder for this project as well for future projects.
Our rules when you get this project:
It is strictly forbidden to download other info/files as we will describe later.