U8登录软件卡顿，消息任务里面有很多消息

问题

• U8客户端登录很慢，加载不正常
  

原因

• U8使用了供应链的审批过程，审批会有很多消息推送，消息任务里面有很多的消息未读，加载的时候，就会去读取消息。导致加载缓慢

解决办法

• 数据库后端清理消息记录，修改【UFsystem】库下的UA_Message表

select *into UA_Message_20231113 from UA_Message    ----备份消息审批记录

delete UA_Message  where  datediff(day,dSend,getdate()) >45  ----保留近45天的消息记录

• 优化索引

DECLARE @SQL nvarchar(1000)
DECLARE @TableName nvarchar(100)

if EXISTS(Select 1 Where @@version Like 'Microsoft SQL Server  2000 %')
 DECLARE crTmp CURSOR OPTIMISTIC FOR
  SELECT [NAME] FROM sysobjects WHERE [xtype] = 'U' Order By [NAME]
ELSE
 DECLARE crTmp CURSOR OPTIMISTIC FOR
  SELECT [NAME] FROM sys.tables WHERE [type] = 'U' Order By [NAME]


OPEN crTmp
FETCH NEXT FROM crTmp INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
    Print '       '   
    Print '========================================================================='   
 Print '当前表：' + @TableName    

 SET @SQL = 'DBCC DBREINDEX([' + @TableName + '])'
 EXECUTE (@SQL)
    
    SET @SQL = 'UPDATE STATISTICS [' + @TableName + ']'
 EXECUTE (@SQL)

 Print '       '  
    Print @TableName + '   执行完毕'
    Print '========================================================================='   
 
 FETCH NEXT FROM crTmp INTO @TableName
END

CLOSE crTmp
DEALLOCATE crTmp

GO

转载：https://www.cnblogs.com/lxhui/p/14953529.html