服务器上运行SQL比笔记本还慢几百倍
服务器配置是：windows server, Xeon E5-2670 v3 2.3GHz + 8G内存。 笔记本电脑是i7-8565U 1.8GHz + 8G内存.
mysql版本是一样的，v5.7.0，服务器的数据是从笔记本的mysqldump导进来的。
但是运行同样的语句，服务器比笔记本还慢很多。
比如跑一个语句，服务器要756秒，笔记本只要2.7秒。 语句是“update a , b set a.tid=b.tid, a.tname=b.tname where a.m=b.m and (a.tid<>b.tid or a.tname<>b.tname)” 。表a有55万条记录，表b有200多条。
请教是什么原因导致的？该如何优化呢？
Subject
Views
Written By
Posted
服务器上运行SQL比笔记本还慢几百倍
2446
October 25, 2021 03:03AM
653
October 25, 2021 03:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.