Skip to content

Speed up todos queries by limiting the projects set we join with

username-removed-506061 requested to merge fix/slow-todos into master

What does this MR do?

Speed up todos queries by limiting the projects set we join with. Todo queries time in dashboard/todos dropped from ~1.5 seconds to ~250ms for my account on production.

Are there points in the code the reviewer needs to double check?

N/A

Why was this MR needed?

Counting and/or listing all todos for a user can be slow if there are lots of projects he can access.

What are the relevant issue numbers?

#20828 (closed)

Screenshots (if relevant)

N/A

Does this MR meet the acceptance criteria?

Merge request reports