2k rows update is very slow in MySQL

Question

Hi all, I have 2 tables: 1. news (450k rows) 2. news_tags (3m rows)

There are some triggers on news table update which updating listings. This SQL executes too long...

UPDATE news
SET news_category = some_number
WHERE news_id IN (SELECT news_id
                  FROM news_tags
                  WHERE tag_id = some_number); #about 3k rows

How can I make it faster?

Thanks in advance, S.

Answer 1

If this is a one time update, you may find it better to disable your triggers, run the update, then run a statement that performs what your triggers do in bulk.