Search code examples
mysqltimequery-performance

Query Update MySQL 5.0 vs 5.7

I have a problem with query performance. I have query update with join like this :

UPDATE table1
JOIN (SELECT table2.a, table2.b 
        FROM table2 
        JOIN table3 ON(table2.x = table3.x) 
        JOIN table4 ON(table4.o = table3.o) 
        GROUP BY table3.o) table_temp ON(table1.key = table_temp.key)
SET variable = table2.b;

In MySQL 5.0 its no problem, that query fast in process. But since I change with MySQL 5.7, that query is slow process. In MySQL 5.0 just need a second time to process them, but in MySQL 5.7 I got in minutes for finish it. What is I must do it?

Solution

  • Im done with change method using Cursor and work perfectly