电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

Pos打开很卡,尤其是在点开台时

来源:金蝶云社区作者:金蝶2024-09-234

 Pos打开很卡,尤其是在点开台时

问题描述:

 Pos打开很卡,尤其是在点开台时

解决方案:

第一种方案:检查数据库tcp/ip 协议 是否开启
 第二种方案:执行下这个脚本
if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_FreeCancID')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_FreeCancID
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_KitFlag')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_KitFlag
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_LangType')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_LangType
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_OrderTime')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_OrderTime
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'PK_POS_BILLFoodBIllID')
Begin
  Drop Index POS_BillFood.PK_POS_BILLFoodBIllID
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_KindNo')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_KindNo
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillFood') and name = 'IX_POS_BillFood_FoodID')
Begin
  Drop Index POS_BillFood.IX_POS_BillFood_FoodID
end

/*****************删除POS_BillFood多余索引*****************/

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_Bill') and name = 'PK_POS_BILLStateID')
Begin
  Drop Index POS_Bill.PK_POS_BILLStateID
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_Bill') and name = 'IX_POS_Bill_BillStateID')
Begin
  Drop Index POS_Bill.IX_POS_Bill_BillStateID
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_Bill') and name = 'IX_POS_Bill_RoomNo')
Begin
  Drop Index POS_Bill.IX_POS_Bill_RoomNo
end

/*****************删除POS_Bill多余索引*****************/

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillState') and name = 'IX_POS_BillState_ActionTime')
Begin
  Drop Index POS_BillState.IX_POS_BillState_ActionTime
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillState') and name = 'IX_POS_BillState_BillState')
Begin
  Drop Index POS_BillState.IX_POS_BillState_BillState
end

if exists (SELECT 1 FROM sysindexes where Id = Object_Id('POS_BillState') and name = 'IX_POS_BillState_EmpID')
Begin
  Drop Index POS_BillState.IX_POS_BillState_EmpID
end

if exists (SELECT 1 F

Pos打开很卡,尤其是在点开台时

问题描述: Pos打开很卡,尤其是在点开台时解决方案:第一种方案:检查数据库tcp/ip 协议 是否开启 第二种方案:执行下这个脚本if exist...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信