批量删除区别

delete() 和 deleteInBatch()
deleteAll() 和 deleteAllInBatch()

普通删除方法会根据唯一标识字段，生成多条 SQL 语句，而有 InBatch 的方法只会生成一条 SQL 语句

写入大量数据

@Transactional
public void save100WEntities() {
    for (int i = 0; i < 1000; i++) {
        respsitory.save(1000Entities);

         entityManager.flush();
        entityManager.clear();
    }
}

读取大量数据

需要满足3个条件：

1. ResultSetType 是 ResultSet.TYPE_FORWARD_ONLY
2. ResultSetConcurrency 是 ResultSet.CONCUR_READ_ONLY
3. FetchSize 是 Integer.MIN_VALUE

Statement statement = connection.createStatement(
        ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
statement.setFetchSize(Integer.MIN_VALUE);

@Repository
public interface UserRepository extends JpaRepository<User, Integer> {
    @QueryHints(value = @QueryHint(name = FETCH_SIZE, value = "" + Integer.MIN_VALUE))
    Stream<User> findByIdIsNotNull();
}

@Transactional
public void run() {
    try (Stream<User> stream = userRepository.findByIdIsNotNull()) {
        stream.forEach(user -> {
            System.out.println(user);
            entityManager.detach(user);
        });
    }
}