search

lealone / Lealone

比 MySQL 和 MongoDB 快10倍的 OLTP 关系数据库和文档数据库
Other
2.48k stars 520 forks source link

更新3799条数据，导致程序卡住了 #189

Closed cbqqkcel closed 1 year ago

cbqqkcel commented 1 year ago

image

cbqqkcel commented 1 year ago

cpu 跑满了

cbqqkcel commented 1 year ago 
update RoomSeller
set saleStatus = 1 where id in (select rsid from RoomSeller as rs, RoomSellerold as rso where rs
and rs.sellerId = rso.seler id)

执行的是这样的语句，是不是in的数据太多了。(3700条)

codefollower commented 1 year ago

换 lealone 5.2 看看有没有问题

codefollower commented 1 year ago

lealone 5.1 嵌套执行 sql，数据量多时有 bug，5.2 修复了。

codefollower commented 1 year ago

我优化了 IN(SELECT) 语句，现在很快了，更新1万行记录也没问题。

cbqqkcel commented 1 year ago

好的谢谢