Resolve "[SQL] Query for person statistics in week overview takes very long" (!164) · Merge requests · AlekSIS® / Official / AlekSIS-App-Alsijil · GitLab

Snippets Groups Projects

Merged Jonathan Weth requested to merge 149-sql-query-for-person-statistics-in-week-overview-takes-very-long into master 4 years ago

All threads resolved!

Closes #149 (closed)

Edited 4 years ago by Jonathan Weth

Activity

Jonathan Weth added part::backend prio::1 source::customer labels 4 years ago

added part::backend prio::1 source::customer labels
Jonathan Weth added 1 commit 4 years ago
added 1 commit

86e7e590 - Optimize query for week view statistics by removing superfluous joins etc.

Compare with previous version
Jonathan Weth assigned to @nik and unassigned @hansegucker 4 years ago

assigned to @nik and unassigned @hansegucker
Jonathan Weth marked this merge request as ready 4 years ago

marked this merge request as ready
Nik | Klampfradler @nik · 4 years ago

Owner

Resolved 4 years ago by Nik | Klampfradler

There's still one distinct() call and a ton of ors.

Please provide the resulting SQL queries before/after.

Last reply by Jonathan Weth 4 years ago
Jonathan Weth @hansegucker started a thread on an old version of the diff 4 years ago

Resolved 4 years ago by Nik | Klampfradler
Last reply by Jonathan Weth 4 years ago

Jonathan Weth added 1 commit 4 years ago

added 1 commit

5d8c1fd5 - Optimize query for week view statistics by removing superfluous joins etc.

Compare with previous version

Nik | Klampfradler resolved all threads 4 years ago

resolved all threads

Nik | Klampfradler merged 4 years ago

merged

Nik | Klampfradler mentioned in commit 4 years ago

mentioned in commit f4664b57

Please register or sign in to reply