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.

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

database: look into other optimization techniques during a job usage update #589

Open
cmoussa1 opened this issue Feb 19, 2025 · 0 comments
Assignees
Labels
improvement Upgrades to an already existing feature

Comments

@cmoussa1
Copy link
Member

It looks like the flux account commands do not hang so badly anymore during a job usage update with the changes made to wrap all of the updates into a single transaction (it used to take more than a couple minutes and now it takes a little less than 8 seconds on a system with very high utilization). I should look to see if there are any other techniques I can use to further optimize the job usage update in addition to wrapping the UPDATE statements into a single transaction, in particular with any of the READ operations from the database.

@cmoussa1 cmoussa1 added the improvement Upgrades to an already existing feature label Feb 19, 2025
@cmoussa1 cmoussa1 self-assigned this Feb 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
improvement Upgrades to an already existing feature
Projects
None yet
Development

No branches or pull requests

1 participant