# simple-shardingsphere-example

**Repository Path**: lixl/simple-shardingsphere-example

## Basic Information

- **Project Name**: simple-shardingsphere-example
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-08-20
- **Last Updated**: 2025-09-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# sharding-jdbc批量插入(mysql)
```
-- rewriteBatchedStatements=true&
10000 500 5.7313393s
10000 1000 2.6624989s
10000 5000 1.9198592s
10000 10000 2.5450089s
10000 10000 2.509591s

-- 无参 
10000 500 69.0736957s
10000 1000 65.5817335s
10000 5000 65.7723962s
10000 10000 65.1716334s
10000 10000 63.4780939s
```
总结：url加上rewriteBatchedStatements参数，BatchSize设置为5000

# sharding分片(分库分表)
[分片](https://shardingsphere.apache.org/document/4.1.1/cn/manual/sharding-jdbc/usage/sharding/)

# sharding事务
[TransactionType三种事务类型](https://www.cnblogs.com/ppku/p/17023127.html)

[sharding分布式事务](https://shardingsphere.apache.org/document/4.1.0/cn/manual/sharding-jdbc/usage/transaction/)