生成抵消表慢可能是数据库中零值数据太多导致的
可以在数据库中查询一下
```sql
select count(1) from T_CR_DYNAMICITEMDATA where FITEMVALUE=0;
select count(1) from T_KDS_RPTITEMDATA where FrptType=31 and FAMOUNT=0;
select count(1) from T_CR_RPTITEMDATA where FrptType=31 and FAMOUNT=0;
```
如果数值特别大：
1、勾选不保存零值项目数据
2、执行删除零值数据的sql
```sql
delete T_CR_DYNAMICITEMDATA where FITEMVALUE=0;
delete t_cr_dynamicdimedata where FENTRYID not in(select FENTRYID from T_CR_DYNAMICITEMDATA);
--删除抵消表零值项目数据
delete T_KDS_RPTITEMDATA where FrptType=31 and FAMOUNT=0;
--删除项目数据关联关系
delete T_KDS_ITEMINRPT where FITEMDATAID not in(select FITEMDATAID from T_KDS_RPTITEMDATA);
--删除抵消表零值项目数据
delete T_CR_RPTITEMDATA where FrptType=31 and FAMOUNT=0;
--删除项目数据关联关系
delete T_CR_ITEMINRPT where FITEMDATAID not in(select FITEMDATAID from T_CR_RPTITEMDATA);
```
