【无标题】

mybatisPlus批量更新优化

<update id="updateDiameterWithNoCompanyId">
    update sort_single_fruit_info
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="diameter = case id" suffix="end">
                <foreach collection="sortSingleFruitInfos" item="item" index="index">
                    when #{item.id} then #{item.diameter}
                </foreach>
            </trim>
            where id in
            <trim>
                <foreach collection="sortSingleFruitInfos" item="item" index="index" open="(" separator="," close=")">
                    #{item.id}
                </foreach>
            </trim>
        </trim>
</update>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

651条时间耗时51毫秒

使用
updateBatchById耗时1500毫秒，加了数据库配置rewriteBatchedStatements=true 效果还是一样慢