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 #751

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

Optimize publication completion by event and target identifier #751

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

Comments

@ciberkleid
Copy link
Contributor

Back-port of GH-749.
@ciberkleid ciberkleid added in: event publication registry Event publication registry type: improvement Minor improvements labels Aug 6, 2024
@ciberkleid ciberkleid added this to the 1.1.8 milestone Aug 6, 2024
@ciberkleid ciberkleid self-assigned this Aug 6, 2024
ciberkleid pushed a commit that referenced this issue Aug 6, 2024
@odrotbohm @ciberkleid
GH-751 - Optimize publication completion by event and target identifier.
ea7b299 
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ciberkleid ciberkleid

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

No branches or pull requests
1 participant
@ciberkleid