- 论坛徽章:
- 0
|
做业务的时候更新表操作慢(前后两个update间隔1分左右):
update ic_account_line
set status = '1'
where sequenceid = @originalsequenceid
select @sqlcode = @@error,
@sqlrowcount = @@rowcount
if @sqlcode != 0
begin
if @sqlcode >; 0 select @sqlcode = (-1) * @sqlcode
return(@sqlcode * 10000 -937
end
update ic_account_line
set status = '1'
where sequenceid = @io_depseqid
select @sqlcode = @@error,
@sqlrowcount = @@rowcount
if @sqlcode != 0
begin
if @sqlcode >; 0 select @sqlcode = (-1) * @sqlcode
return(@sqlcode * 10000 -9379)
end
===================
建表脚本:
create table dbo.trans_line (
voucherid numeric(12, 0) not null,
cardid char(1 null,
......
belongdate datetime not null,
sequenceid numeric(12, 0) null,
recoveryvoucherid numeric(12, 0) null,
status char(1) DEFAULT '0' /*交易冲正标志,1冲正*/
not null,
constraint pk_trans_line PRIMARY KEY NONCLUSTERED ( voucherid)
)
on 'default'
go
create nonclustered index sequenceid_idx
on dbo.trans_line (sequenceid)
on 'default'
go
exec sp_bindrule 'dbo.direction_rule', 'trans_line.direction'
go
exec sp_bindrule 'dbo.trans_method_rule', 'trans_line.transmethod'
go
exec sp_bindrule 'dbo.voucher_type_rule', 'trans_line.vouchertype'
go
=========================
trans_line表中数据大概有200万行. Lock scheme datapages |
|