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

Optimize publication completion by event and target identifier #749

Closed
odrotbohm opened this issue Aug 6, 2024 · 0 comments
Closed

Optimize publication completion by event and target identifier #749

odrotbohm opened this issue Aug 6, 2024 · 0 comments
Assignees
@odrotbohm
Labels
in: event publication registry Event publication registry type: improvement Minor improvements
Milestone
1.3 M2

Comments

@odrotbohm
Copy link
Member

No description provided.

@odrotbohm odrotbohm added in: event publication registry Event publication registry type: improvement Minor improvements labels Aug 6, 2024
@odrotbohm odrotbohm added this to the 1.3 M2 milestone Aug 6, 2024
@odrotbohm odrotbohm self-assigned this Aug 6, 2024
@odrotbohm odrotbohm changed the title Optimize completion by event and target identifier Optimize publication completion by event and target identifier Aug 6, 2024
odrotbohm added a commit that referenced this issue Aug 6, 2024
@odrotbohm
GH-749 - Optimize publication completion by event and target identifier.
4802089 
We now additionally guard the completion query by event and target identifier to also only apply to publications that have not been completed yet. This will allow databases to optimize the query plan to apply simple comparisons (the date being null) over complex comparisons (the event payload) to reduce the intermediate results to process further and thus improve performance.
This was referenced Aug 6, 2024
Closed
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@odrotbohm odrotbohm

Labels
in: event publication registry Event publication registry type: improvement Minor improvements
Projects
None yet
Milestone
1.3 M2
Development

No branches or pull requests
2 participants
@odrotbohm @ciberkleid