Skip to content

Provide a way to query for BusinessKey in JDBC schema #3413

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
Closed
fjtirado opened this issue Feb 22, 2024 · 0 comments · Fixed by #3441
Closed

Provide a way to query for BusinessKey in JDBC schema #3413

fjtirado opened this issue Feb 22, 2024 · 0 comments · Fixed by #3441
Assignees
@fjtirado

Comments

@fjtirado
Copy link
Contributor

fjtirado commented Feb 22, 2024 •
edited
Loading

Description

Currenlty the only way to find a process given its business key is to perform a linear search, which in turn implies unmarshalling the content of payload column. It would be good, performance wise, to create new indexed column and store business key there.

Implementation ideas

Add a new indexed column called businessKey and use it in searches by businessKey.
This was referenced Feb 22, 2024
Merged
Closed
@fjtirado fjtirado self-assigned this Feb 22, 2024
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 14, 2024
@fjtirado
[Fix apache#3413] Speed up businesskey query performance
0c729c7
@fjtirado fjtirado mentioned this issue Mar 14, 2024
Merged
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 14, 2024
@fjtirado
[Fix apache#3413] Speed up businesskey query performance
ab9f0fa
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 14, 2024
@fjtirado
[Fix apache#3413] Speed up business key query performance
c358036
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 15, 2024
@fjtirado
[Fix apache#3413] Speed up business key query performance
d2cc28d
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 15, 2024
@fjtirado
[Fix apache#3413] Walters comments
baa774b
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 15, 2024
@fjtirado
[Fix apache#3413] Walters comments
cc3587f
fjtirado added a commit to fjtirado/kogito-runtimes that referenced this issue Mar 15, 2024
@fjtirado
[Fix apache#3413] Fixing flaky test
876b844
fjtirado added a commit that referenced this issue Mar 16, 2024
@fjtirado
[Fix_#3413] Speed up businesskey query performance (#3441)
1c82652 
* [Fix #3413] Speed up business key query performance

* [Fix #3413] Walters comments

* [Fix #3413] Fixing flaky test
@github-project-automation github-project-automation bot moved this from 📋 Backlog to 🎯 Done in 🦉 KIE Podling Board Mar 16, 2024
rgdoliveira pushed a commit to rgdoliveira/kogito-runtimes that referenced this issue Mar 27, 2024
@fjtirado @rgdoliveira
[Fix_#3413] Speed up businesskey query performance (apache#3441)
3f0d772 
* [Fix apache#3413] Speed up business key query performance

* [Fix apache#3413] Walters comments

* [Fix apache#3413] Fixing flaky test
@fjtirado fjtirado mentioned this issue Nov 28, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@fjtirado fjtirado

Labels
None yet
Projects
🦉 KIE Podling Board
Archived in project
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[Fix_#3413] Speed up businesskey query performance fjtirado/kogito-runtimes
1 participant
@fjtirado