MySQL的速度问题 [英] Speed Issue with MySQL

问题描述

嗨朋友们，



我有一个名为grn_items的表，我正在尝试执行简单的更新查询。

Hi friends,

I have a table called grn_items and i am trying to execute simple update query .

update grn_items set uid=1;

它共有823行，我需要更新一个uid列。



但是需要花费很多时间来更新（超过20分钟）。



任何人都可以帮助我。

It has total 823 rows and i need to update a uid column.

But it is taking lot of time to update(more than 20min).

Can anyone help me out.

推荐答案

update grn_items set uid = 1;

和

是......更新触发器

=>看见？问题是由您的触发器引起的（可能还会嵌套在其中）。

"update grn_items set uid=1;"
and
"yes... on update trigger "
=> see it? The problem is caused by your trigger (and maybe further nested therein).

这篇关于MySQL的速度问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！