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

Improve performance of UDP submission query #1464

Closed
jonespm opened this issue Dec 19, 2022 · 0 comments · Fixed by #1465
Closed

Improve performance of UDP submission query #1464

jonespm opened this issue Dec 19, 2022 · 0 comments · Fixed by #1465

Comments

@jonespm
Copy link
Member

jonespm commented Dec 19, 2022

Expected behavior (A description of what you expected to happen) :

UDP query should be able to run in a similar speed to UDW query

Describe the bug (Tell us what happens instead of the expected behavior) :

We've noticed when running the cron that the UDP submission query is taking the majority of time to run and taking a long time, almost an hour for many courses. There should still be improvements to be made with this query.

We have some sample query plans in the My Learning Analytics T&L shared folder. Initial investigation is that using a temporary table might work well.

jonespm added a commit to jonespm/student-dashboard-django that referenced this issue Dec 19, 2022
@jonespm jonespm added this to To do in MyLA-2022.02.01 via automation Dec 19, 2022
@jonespm jonespm moved this from To do to In progress in MyLA-2022.02.01 Dec 19, 2022
@jonespm jonespm linked a pull request Dec 19, 2022 that will close this issue
MyLA-2022.02.01 automation moved this from In progress to Review/QA Dec 19, 2022
@jennlove-um jennlove-um moved this from Review/QA to Done in MyLA-2022.02.01 Dec 21, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
No open projects
Development

Successfully merging a pull request may close this issue.

1 participant