【问】进系统后财务结算模块反应非常慢
【适用版本】商锐9	【模块】档案管理	【点击数】76
【知识编号】P2015072100036
【问题描述】进系统后财务结算模块反应非常慢

【答】 请备份数据库执行以下语句：
use hbposv8
go
delete t_sys_sheet_master_info where main_name like ‘%费用%’
go
delete t_sys_sheet_detail_info where main_name like ‘%费用%’
go
delete t_sys_sheet_master_info where main_name like ‘%结算%’
go
delete t_sys_sheet_detail_info where main_name like ‘%结算%’
go
delete t_sys_sheet_master_info where main_name like ‘%付款%’
go
delete t_sys_sheet_detail_info where main_name like ‘%付款%’
go
delete t_sys_sheet_master_info where main_name like ‘%收款%’
go
delete t_sys_sheet_detail_info where main_name like ‘%收款%’
go
delete t_sys_sheet_master_info where main_name like   ‘%账款%’
go
delete t_sys_sheet_detail_info  where main_name like  ‘%账款%’
go
delete t_sys_sheet_psr_info
go