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打开很卡,尤其是在点开台时
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



