apache / apache/shardingsphere
Optimize the performance consumption of ShardingSphere and Seata to parse SQL repeatedly
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 10h 33m
- Merged PRs (30d)
- 341
Description
## Feature Request
### Is your feature request related to a problem?
No.
### Describe the feature you would like.

At present, ShardingSphere integrates Seata to implement Base transactions, and has achieved good results. But there is still a problem, both ShardingSphere and Seata parse the SQL when processing it, which leads to additional performance overhead.
In order to optimize the performance of the integrated use of ShardingSphere and Seata, we need to integrate the SQL parsing of ShardingSphere and Seata, and pass the AST of ShardingSphere to Seata to avoid the problem of repeated SQL parsing.
Contributor guide
Research direction
Start by investigating the ShardingSphere and Seata integration described in the issue, focusing on where both systems parse SQL. Determine how ShardingSphere's AST could be passed to Seata and how performance improvements would be measured; the issue names no files or tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases, distributed-systems, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100