【Mybatis】mybatis原生与mybatis-puls效率比较

【Mybatis】mybatis原生与mybatis-puls效率比较

背景

• mybatis-plus是近年来最流行的mybatis敏捷开发的插件,提供了简单的crud与条件查询.我们现在就来比较一下mybatis-plus与原生的mybatis比较一下效率问题
• mybatis-plus官网

开始

我们先的有一个工具,能知道mapper层代码的执行时间,这个在我的博客里已经有了.需要的朋友可以去查看【日志】logback 耗时性能监控与使用

代码

• 原生

package com.emodernhy.generator.mode;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.IdType;
import java.util.Date;
import com.baomidou.mybatisplus.annotation.TableId;
import java.io.Serializable;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

/**
 * <p>
 * 样本01
 * </p>
 *
 * @author bo.huang
 * @since 2020-04-23
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("t_demo")
@ApiModel(value="Demo对象", description="样本01")
public class Demo implements Serializable {

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "demo_id", type = IdType.AUTO)
    private Integer demoId;

    @ApiModelProperty(value = "名称")
    private String demoName;

    @ApiModelProperty(value = "时间")
    private Date demoCreatetime;


}

@RestController
@RequestMapping("/demo")
@Api(value = "样本测试01",tags="样本测试01")
public class DemoController {

    @Autowired
    private IDemoService demoService;

    /**
     * 保存
     *
     * @param demo demo
     * @return java.lang.String
     * @author bo.huang update
     * @date 2020/4/23 2:38 下午
     */
    @PostMapping
    @Perf4Log
    public String save(@RequestBody Demo demo) {
        demo.setDemoName("黄波" + System.currentTimeMillis());
        demo.setDemoCreatetime(new Date());
        demoService.save(demo);
        return "保存成功";
    }

    @PostMapping("batch")
    @ApiOperation("批量保存")
    @Perf4Log
    public String savebatch(@RequestParam("count") Integer count) {
        List<Demo> list = new ArrayList<>();
        Demo demo;
        for (int i = 0; i < count; i++) {
            demo = new Demo();
            demo.setDemoName("黄波" + System.currentTimeMillis());
            demo.setDemoCreatetime(new Date());
            list.add(demo);
        }
        demoService.saveBatch(list);
        return "保存成功";
    }
}
@Service
public class DemoServiceImpl implements IDemoService {

    @Autowired
    private DemoMapper demoMapper;

    @Override
    public void save(Demo demo) {
        demoMapper.insert(demo);
    }

    @Override
    public void saveBatch(List<Demo> list) {
        demoMapper.insertBatch(list);
    }
}

public interface DemoMapper extends BaseMapper<Demo> {

    /**
     * 批量保存
     *
     * @param list list
     * @author bo.huang update
     * @date 2020/4/23 2:42 下午
     */
    void insertBatch(@Param("demos") List<Demo> list);
}

• mybatis-plus

@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("t_demo_plus")
@ApiModel(value="DemoPlus对象", description="样本02")
public class DemoPlus implements Serializable {

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "demo_id", type = IdType.AUTO)
    private Integer demoId;

    @ApiModelProperty(value = "名称")
    private String demoName;

    @ApiModelProperty(value = "时间")
    private Date demoCreatetime;


}

@RestController
@RequestMapping("/demoPlus")
@Api(value = "样本测试02",tags="样本测试02")
public class DemoPlusController {

    @Autowired
    private IDemoPlusService demoPlusService;

    /**
     * 保存
     *
     * @param demo demo
     * @return java.lang.String
     * @author bo.huang update
     * @date 2020/4/23 2:38 下午
     */
    @PostMapping
    @ApiOperation("保存-plus")
    @Perf4Log
    public String save(@RequestBody DemoPlus demo) {
        demo.setDemoName("黄波" + System.currentTimeMillis());
        demo.setDemoCreatetime(new Date());
        demoPlusService.save(demo);
        return "保存成功";
    }

    @PostMapping("batch")
    @ApiOperation("批量保存-plus")
    @Perf4Log
    public String savebatch(@RequestParam("count") Integer count) {
        List<DemoPlus> list = new ArrayList<>();
        DemoPlus demo;
        for (int i = 0; i < count; i++) {
            demo = new DemoPlus();
            demo.setDemoName("黄波" + System.currentTimeMillis());
            demo.setDemoCreatetime(new Date());
            list.add(demo);
        }
        demoPlusService.saveBatch(list);
        return "保存成功";
    }

}

@Service
public class DemoPlusServiceImpl extends ServiceImpl<DemoPlusMapper, DemoPlus> implements IDemoPlusService {

}

public interface DemoPlusMapper extends BaseMapper<DemoPlus> {

}

执行save单个保存方法

由此可以看出来.原生的单个保存方法与plus的保存方法差不多效率

执行批量保存方法

一次性保存100条数据

由此可以得出原生的效率大于plus插件的
一次性保存1000条

由此看来,一次性保存数据越大,plus的越慢,这是为什么呢

查看plus源码得到结论

看到这里.知道plus是默认一次性吧1000条数据.一条条执行放入预处理对象中,到最后提交.也就是它是一条一条的插入,最后在整体提交事务的.所以最后作者建议,大批量的保存还是用原生的mybatis