Question

当我用触发器更新了100份记录时,它需要15秒钟才能执行,但是如果我没有触发,只需要2份。

这符合当地发展版本,生产需要两分钟。我能否加快这一进程?

感谢。

  DROP TRIGGER IF EXISTS imuebles_update;
  DELIMITER |
  CREATE TRIGGER imuebles_update AFTER UPDATE ON imuebles
  FOR EACH ROW
  BEGIN

    IF NEW.pub_id IS NULL THEN
      DELETE FROM search_engine WHERE id = NEW.idImuebles;
    ELSE
      REPLACE INTO search_engine SELECT * FROM search_engine_v WHERE id = NEW.idImuebles;
    END IF;

  END;
  |

  DELIMITER ;

Answer 1

这对我来说是好的。

REPLACE INTO search_engine SELECT * FROM search_engine_v WHERE id = NEW.idImuebles;

在更新后,每行都可能有相当沉重的关税。

My guess is that it would require a good look at why this is required rather than being a simple fix.

如果你公布一些数据库结构信息,也许有些人可以建议如何加以确定。

友情链接