2k rows update is very slow in MySQL
- by sergeik
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.
