专业版12.0出纳保存删除特别慢

hudan160

624次浏览编辑于2016年03月16日 15:16:00

客户是专业版12.0的版本，数据库为2005，系统为XP系统，客户使用中的账套出纳每次保存数据或者删除记录都特别慢，至少要等半分钟到1分钟一笔，其他的总账正常，换了用户名换了客户端或服务器均如此，测试演示账套不重现。追踪数据库语句发现，增加同样的记录，问题账套数据库执行语句多了很多语句，其中有很多重复语句。
语句如下：
一共有2段是多余的语句：
第一段：
------------select FAcctName from t_ad_kdAccount_gl where FDBName = 'AIS20131202143638'
go
select * from sysdatabases where name='AIS20131202143638' go
select FVersion from t_ad_kdAccount_gl where FDBName = 'AIS20131202143638'
go
if not exists(Select * From syscolumns C inner Join sysobjects T On T.ID=C.ID And T.Name='t_ad_kdAccount_gl' And T.xtype='u' And C.Name='FAutoBakSet') alter table t_ad_kdAccount_gl add FAutoBakSet Varchar(400) not null default('')
go
if not exists(Select * From syscolumns C inner Join sysobjects T On T.ID=C.ID And T.Name='t_ad_kdAccount_gl' And T.xtype='u' And C.Name='FAutoBakLog') alter table t_ad_kdAccount_gl add FAutoBakLog Varchar(400) not null default('')
go
if not exists(Select * From syscolumns C inner Join sysobjects T On T.ID=C.ID And T.Name='t_ad_kdAccount_gl' And T.xtype='u' And C.Name='FAutoBakTime') alter table t_ad_kdAccount_gl add FAutoBakTime smalldatetime null default('')
go
Select FAcctName,FDBName,FAutoBakSet,FAutoBakLog,FAutoBakTime from t_ad_kdAccount_gl
-----------------go
第二段
------------------select * from t_account where FAccountID=0
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
select * from t_account where FAccountID=0
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
select * from t_account where FAccountID=0
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
select * from t_account where FAccountID=0
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
select * from t_account where FAccountID=0
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NOCOUNT OFF
go
后面一直这样重复，差不多重复200行左右

赞 0 评论 2 收藏

专业版12.0出纳保存删除特别慢

恭喜您！