apache / apache/shardingsphere

Optimize the performance consumption of ShardingSphere and Seata to parse SQL repeatedly

Open
#20,697 1 comment 1 reaction 0 assignees View on GitHub
feature: transaction type: enhancement
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.

![image](https://user-images.githubusercontent.com/10829171/187697846-105fe8a2-751f-4fd8-be36-d4affc4d4cfa.png)

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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.