同时建有多个用户数据库(目前有6个,以后会增加),其中一个是基础数据库,在这个数据库中定义的基础信息会同步下发到其它数据库中,是用触发器来实现的。目前出现的问题是当定义基础数据时速度很慢,造成用户一段时间不能使用(少则十几分钟),不知道是不是触发器写的有问题。
这是其中的一个CREATE trigger aaa_update on aaa for UPDATE as delete base1.dbo.aaa from base1.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base1.dbo.aaa select * from inserteddelete base2.dbo.aaa from base2.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base2.dbo.aaa select * from inserted delete base3.dbo.aaa from base3.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base3.dbo.aaa select * from inserted ...............
这是其中的一个CREATE trigger aaa_update on aaa for UPDATE as delete base1.dbo.aaa from base1.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base1.dbo.aaa select * from inserteddelete base2.dbo.aaa from base2.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base2.dbo.aaa select * from inserted delete base3.dbo.aaa from base3.dbo.aaa as a ,inserted as b where a.wpdm=b.wpdm insert into base3.dbo.aaa select * from inserted ...............
CREATE trigger aaa_update
on aaa
for UPDATE
as
insert into base1.dbo.aaa
select * from inserted d where not exists (select 1 from inserted d,aaa a where a.id=d.id and a.wpdm=d.wpdm)
go
on aaa
for UPDATE
as
insert into base1.dbo.aaa
select * from inserted d where not exists
(select 1 from inserted d,aaa a where a.id=d.id and a.wpdm=d.wpdm)
go