mybatis plus 5种批量操作性能测试

package com.wm.demo1.service; import com.wm.demo1.entity.*; import com.wm.demo1.ignite.repository.PersonRepository; import com.wm.demo1.mapper.*; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.support.TransactionTemplate; import java.util.ArrayList; import java.util.List; import java.util.Random; /********************************************************** * 类描述： * 创建人：王锰 * 创建时间：2021年03月25日 下午3:07 * 修改备注： **********************************************************/ @Service @Slf4j public class PersonService { @Autowired private PersonRepository personRepository; @Autowired private PersonMapper personMapper; @Autowired private ChildOneService childOneService; @Autowired private ChildTwoService childTwoService; @Autowired private ChildThreeService childThreeService; @Autowired private ChildFourService childFourService; @Autowired private ChildOneMapper childOneMapper; @Autowired private ChildTwoMapper childTwoMapper; @Autowired private ChildThreeMapper childThreeMapper; @Autowired private ChildFourMapper childFourMapper; @Autowired private TransactionTemplate transactionTemplate; public Person save(Person person) { final Person save = personRepository.save(person.getId(), person); log.info("save:{}", person.toString()); return save; } public Person findById(Long id) { return personRepository.findById(id).orElseThrow(() -> new RuntimeException("id不存在")); } public List<Person> findAll() { final Iterable<Person> all = personRepository.findAll(); List<Person> list = new ArrayList<>(); all.forEach(list::add); return list; } public void testOneInsert(int num) { int parentId = 10000; String json = "{\"appid\":\"wx431fef5c79711f2b\",\"body\":\"商品缴费\",\"busiScopeNo\":\"WS\",\"cardinfo\":[],\"chongzhiUrl\":\"充值URL暂不需要\",\"goods\":[{\"quantity\":1,\"price\":\"payTotalPrice\",\"goodsName\":\"外卖单\"}],\"items\":[{\"calcPrice\":4,\"code\":\"101001\",\"hyjFlg\":\"1\",\"istc\":\"0\",\"itemMOList\":[{\"addPr\":\"0\",\"addPrType\":0,\"moID\":136,\"moName\":\"特辣\",\"qty\":1}],\"itemcount\":1,\"itemid\":720,\"itemname\":\"长沙臭豆腐@大份\",\"mljFlg\":\"1\",\"npartPr\":9,\"price\":9,\"skuinfo\":\"瓶\",\"unID\":-1,\"unName\":\"瓶\",\"vipPrice\":4}],\"kind\":\"10325\",\"login_token\":\"2c6y2fo6XJLdAx+3mUQStw==\",\"money\":15.00,\"mpid\":\"gh_8a00eb1a4d42\",\"openid\":\"oYo7s4pDj0ysGiu5R5pCi3J_e__k\",\"order_entry\":\"pages/index\",\"orderid\":\"6103821289091233874922\",\"otherBillAmount\":\"11\",\"otherBillAmountRemark\":\"餐盒费1，配送费10\",\"parentOpenid\":\"\",\"payBusinNo\":\"6103821289091233874922\",\"payFrom\":3,\"payMoney\":15.00,\"paySerialNo\":\"\",\"payTypeProd\":\"miniProgram\",\"payhuis\":[{\"huiprice\":5,\"huiremark\":\"微信会员价结算立减5元\",\"huitypeid\":\"1\"},{\"huiprice\":0,\"huiremark\":\"促销方案价结算立减0元\",\"huitypeid\":\"3\"},{\"huiprice\":0,\"huiremark\":\"满N优惠结算立减0元\",\"huitypeid\":\"5\"},{\"huiprice\":0,\"huiremark\":\"配送费满减0元\",\"huitypeid\":\"4\"}],\"paytypeid\":0,\"storeid\":\"7178\",\"trueMoney\":15.00,\"turnUrl\":\"跳转URL暂不需要\",\"udStateUrl\":\"http://alpha2.wuuxiang.com/api/tcsl/UpdateDeInfo.htm\",\"unionid\":\"obts_wTIPXjQX8sUCkzFP-cYC-ko\"}"; Person person = new Person(); person.setId(parentId); person.setName("wangxiaoming"); List<ChildOne> listOne = new ArrayList<>(); List<ChildTwo> listTwo = new ArrayList<>(); List<ChildThree> listThree = new ArrayList<>(); List<ChildFour> listFour = new ArrayList<>(); for (int i = 0; i < num; i++) { ChildOne childOne = new ChildOne(); ChildTwo childTwo = new ChildTwo(); ChildThree childThree = new ChildThree(); ChildFour childFour = new ChildFour(); final int id = 1000; childOne.setId(id + i); childTwo.setId(id + i); childThree.setId(id + i); childFour.setId(id + i); childOne.setParentId(parentId); childTwo.setParentId(parentId); childThree.setParentId(parentId); childFour.setParentId(parentId); childOne.setJson(json); childTwo.setJson(json); childThree.setJson(json); childFour.setJson(json); listOne.add(childOne); listTwo.add(childTwo); listThree.add(childThree); listFour.add(childFour); } PersonAll personAll = new PersonAll(); personAll.setPerson(person); personAll.setListOne(listOne); personAll.setListTwo(listTwo); personAll.setListThree(listThree); personAll.setListFour(listFour); long start = System.currentTimeMillis(); transactionTemplate.execute(status -> { personMapper.insertAll(personAll); return true; }); log.info("一次发送多个表的insert语句，insert使用多value方式。time:{}", System.currentTimeMillis() - start); } public void testOneInsert2(int num) { int parentId = 10000; String json = "{\"appid\":\"wx431fef5c79711f2b\",\"body\":\"商品缴费\",\"busiScopeNo\":\"WS\",\"cardinfo\":[],\"chongzhiUrl\":\"充值URL暂不需要\",\"goods\":[{\"quantity\":1,\"price\":\"payTotalPrice\",\"goodsName\":\"外卖单\"}],\"items\":[{\"calcPrice\":4,\"code\":\"101001\",\"hyjFlg\":\"1\",\"istc\":\"0\",\"itemMOList\":[{\"addPr\":\"0\",\"addPrType\":0,\"moID\":136,\"moName\":\"特辣\",\"qty\":1}],\"itemcount\":1,\"itemid\":720,\"itemname\":\"长沙臭豆腐@大份\",\"mljFlg\":\"1\",\"npartPr\":9,\"price\":9,\"skuinfo\":\"瓶\",\"unID\":-1,\"unName\":\"瓶\",\"vipPrice\":4}],\"kind\":\"10325\",\"login_token\":\"2c6y2fo6XJLdAx+3mUQStw==\",\"money\":15.00,\"mpid\":\"gh_8a00eb1a4d42\",\"openid\":\"oYo7s4pDj0ysGiu5R5pCi3J_e__k\",\"order_entry\":\"pages/index\",\"orderid\":\"6103821289091233874922\",\"otherBillAmount\":\"11\",\"otherBillAmountRemark\":\"餐盒费1，配送费10\",\"parentOpenid\":\"\",\"payBusinNo\":\"6103821289091233874922\",\"payFrom\":3,\"payMoney\":15.00,\"paySerialNo\":\"\",\"payTypeProd\":\"miniProgram\",\"payhuis\":[{\"huiprice\":5,\"huiremark\":\"微信会员价结算立减5元\",\"huitypeid\":\"1\"},{\"huiprice\":0,\"huiremark\":\"促销方案价结算立减0元\",\"huitypeid\":\"3\"},{\"huiprice\":0,\"huiremark\":\"满N优惠结算立减0元\",\"huitypeid\":\"5\"},{\"huiprice\":0,\"huiremark\":\"配送费满减0元\",\"huitypeid\":\"4\"}],\"paytypeid\":0,\"storeid\":\"7178\",\"trueMoney\":15.00,\"turnUrl\":\"跳转URL暂不需要\",\"udStateUrl\":\"http://alpha2.wuuxiang.com/api/tcsl/UpdateDeInfo.htm\",\"unionid\":\"obts_wTIPXjQX8sUCkzFP-cYC-ko\"}"; Person person = new Person(); person.setId(parentId); person.setName("wangxiaoming"); List<ChildOne> listOne = new ArrayList<>(); List<ChildTwo> listTwo = new ArrayList<>(); List<ChildThree> listThree = new ArrayList<>(); List<ChildFour> listFour = new ArrayList<>(); for (int i = 0; i < num; i++) { ChildOne childOne = new ChildOne(); ChildTwo childTwo = new ChildTwo(); ChildThree childThree = new ChildThree(); ChildFour childFour = new ChildFour(); final int id = 1000; childOne.setId(id + i); childTwo.setId(id + i); childThree.setId(id + i); childFour.setId(id + i); childOne.setParentId(parentId); childTwo.setParentId(parentId); childThree.setPa