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

疯狂的狮子Li

2024-06-28 a4fe077a231ed2ae0094af0fc6fa0735b764c862

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

@@ -154,6 +154,7 @@
            }
            row = baseMapper.updateById(config);
        } else {
            CacheUtils.evict(CacheNames.SYS_CONFIG, config.getConfigKey());
            row = baseMapper.update(config, new LambdaQueryWrapper<SysConfig>()
                .eq(SysConfig::getConfigKey, config.getConfigKey()));
        }
@@ -177,7 +178,7 @@
            }
            CacheUtils.evict(CacheNames.SYS_CONFIG, config.getConfigKey());
        }
        baseMapper.deleteBatchIds(Arrays.asList(configIds));
        baseMapper.deleteByIds(Arrays.asList(configIds));
    }

    /**