Re: update queries taking 1 week to finish

[Rick James]

> Would having so many descriptors be an issue ?

30M rows is not necessarily a problem. It depends on the indexes and the queries.

Please use SHOW CREATE TABLE because it is more descriptive than DESCRIBE.

Using "aliases" will make the SQL less cluttered:

UPDATE         result AS r
   INNER JOIN  numbers_trig AS t
        ON t.n1 = r.n$n1
      AND  t.n2 = r.n$n2
      AND  t.n3 = r.n$n3
      AND  t.n4 = r.n$n4
      AND  t.n5 = r.n$n5
      and  t.n6 = r.n$n6
    SET r.status= 6;