Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

批量插入时生成的超长sql执行时间过长 #131

Open
Airoucat233 opened this issue Aug 30, 2023 · 1 comment
Open

批量插入时生成的超长sql执行时间过长 #131

Airoucat233 opened this issue Aug 30, 2023 · 1 comment

Comments

@Airoucat233
Copy link

今天升级到了最新版本(5.0.8.2),发现程序中批量插入的方法执行时间变得很长很长,500条数据等了我1分多钟,达到了不可用的地步。没有查看源码,不知是否是对sql进行了解析处理操作,导致遇到超长的sql时解析时间过长?升级前的版本没有这个问题,1.几还是2.几还是3.几不太记得了,目前替换为了Marketplace中的mybatis log free这个使用正常,希望能够尽快修复,新版本的sql折叠,样式都挺好的

mybatis批量插入xml如下,实体类字段很多,一次性插入500条生成的sql就非常长

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into online_violation_penalty(type,violation_type,nature, continuous_violation_count,violation_count,punishment_type,quarter, yearmonth, week, ykdept_id, ykdept_name,dept_id,dept_name, company_id, company_name,shop_name, company_type, is_bmd, company_bmdlx,goods_id, goods_name, goods_type,expiration_date, platform, url,provincial_manager_id, provincial_manager_name, provincial_manager_amount, maintainer_id, maintainer_name, maintainer_amount,update_time)
        values
        <foreach collection="list" item="entity" separator=",">
        (#{entity.type},#{entity.violationType},#{entity.nature},#{entity.continuousViolationCount},#{entity.violationCount},#{entity.punishmentType}, #{entity.quarter}, #{entity.yearmonth}, #{entity.week}, #{entity.ykdeptId}, #{entity.ykdeptName},#{entity.deptId}, #{entity.deptName}, #{entity.companyId}, #{entity.companyName}, #{entity.shopName},#{entity.companyType}, #{entity.isBmd}, #{entity.companyBmdlx},#{entity.goodsId}, #{entity.goodsName}, #{entity.goodsType},#{entity.expirationDate}, #{entity.platform}, #{entity.url}, #{entity.provincialManagerId}, #{entity.provincialManagerName}, #{entity.provincialManagerAmount}, #{entity.maintainerId}, #{entity.maintainerName}, #{entity.maintainerAmount},#{entity.updateTime})
        </foreach>
    </insert>
@Link-Kou
Copy link
Owner

Link-Kou commented Sep 3, 2023

@Airoucat233 收到。我测试一下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants