Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cache PathExpression to improve the performance of JSON function #35859

Closed
wjhuang2016 opened this issue Jun 30, 2022 · 0 comments · Fixed by #35860
Closed

Cache PathExpression to improve the performance of JSON function #35859

wjhuang2016 opened this issue Jun 30, 2022 · 0 comments · Fixed by #35860
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@wjhuang2016
Copy link
Member

Enhancement

When adding an index for a generated column related to JSON, computing the PathExpression would cause much CPU resource, we can cache the PathExpression since it's not changed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

types: cache pathExpression to improve the JSON function performance wjhuang2016/tidb
1 participant
@wjhuang2016