Count: 16 Time=8.13s (130s) Lock=0.00s (0s) Rows=0.0 (0), gedevuser[gedevuser]@[10.2.6.43]
update xxx set ProcessType=N,ProcessFileName='S' ,UpdaterId=N,UpdateDate=now() where ProcessId=NCount: 11 Time=10.12s (111s) Lock=0.00s (0s) Rows=0.0 (0), gedevuser[gedevuser]@3hosts
update xx set ProcessStatus='S' , DealStatus ='S', processFileName = 'S' ,updaterId = N, updateDate=now() where ProcessType='S' and fileid='S'ProcessId 为主键,fileid建了索引,怎么主键 跟新还那么慢??
update xxx set ProcessType=N,ProcessFileName='S' ,UpdaterId=N,UpdateDate=now() where ProcessId=NCount: 11 Time=10.12s (111s) Lock=0.00s (0s) Rows=0.0 (0), gedevuser[gedevuser]@3hosts
update xx set ProcessStatus='S' , DealStatus ='S', processFileName = 'S' ,updaterId = N, updateDate=now() where ProcessType='S' and fileid='S'ProcessId 为主键,fileid建了索引,怎么主键 跟新还那么慢??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货