详解mybatis批量插入10万条数据的优化过程

package com.lcy.service.mapper;

import com.lcy.service.pojo.TestVO;

import org.apache.ibatis.annotations.Insert;

import java.util.List;

public interface TestMapper {

     @Insert ( "" )

     Integer testBatchInsert(List list);

}

package com.lcy.service.pojo;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

@Data

@NoArgsConstructor

@AllArgsConstructor

public class TestVO {

     private String t1;

     private String t2;

     private String t3;

     private String t4;

     private String t5;

}

import com.lcy.service.TestApplication;

import com.lcy.service.mapper.TestMapper;

import com.lcy.service.pojo.TestVO;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import java.util.ArrayList;

import java.util.List;

@SpringBootTest (classes = TestApplication. class )

@RunWith (SpringRunner. class )

public class TestDemo {

     @Autowired

     private TestMapper testMapper;

     @Test

     public void insert() {

         List list = new ArrayList<>();

         for ( int i = 0 ; i < 200000 ; i++) {

             list.add( new TestVO(i + "," + i, i + "," + i, i + "," + i, i + "," + i, i + "," + i));

         }

         System.out.println(testMapper.testBatchInsert(list));

     }

}

import com.lcy.service.TestApplication;

import com.lcy.service.mapper.TestMapper;

import com.lcy.service.pojo.TestVO;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import javax.swing.*;

import java.util.ArrayList;

import java.util.List;

import java.util.stream.Collectors;

@SpringBootTest (classes = TestApplication. class )

@RunWith (SpringRunner. class )

public class TestDemo {

     @Autowired

     private TestMapper testMapper;

     @Test

     public void insert() {

         List list = new ArrayList<>();

         for ( int i = 0 ; i < 200000 ; i++) {

             list.add( new TestVO(i + "," + i, i + "," + i, i + "," + i, i + "," + i, i + "," + i));

         }

         int index = list.size() / 10000 ;

         for ( int i= 0 ;i< index;i++){

             //stream流表达式，skip表示跳过前i*10000条记录，limit表示读取当前流的前10000条记录

             testMapper.testBatchInsert(list.stream().skip(i* 10000 ).limit( 10000 ).collect(Collectors.toList()));

         }

     }

}