update 优化 大数据量下join卡顿问题 使用子查询提高性能

疯狂的狮子Li

2024-06-28 a4fe077a231ed2ae0094af0fc6fa0735b764c862

 ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysPostServiceImpl.java

@@ -202,7 +202,7 @@
                throw new ServiceException(String.format("%1$s已分配，不能删除!", post.getPostName()));
            }
        }
        return baseMapper.deleteBatchIds(Arrays.asList(postIds));
        return baseMapper.deleteByIds(Arrays.asList(postIds));
    }

    /**