Skip to content

Restrict use of CTE fence to dashboards/projects#index

Stan Hu requested to merge sh-restrict-cte-project-dashboard into master

In !23754 (merged), we added a CTE optimization fence to ensure loading a user's projects is always fast.

However, using a CTE for the dashboard/projects/starred endpoint is less efficient than the default query because that endpoint also loads public and internal projects. For now, we can just restrict use of this CTE for the index action.

In the future, we may want to put this logic inside ProjectsFinder.

Closes #201994 (closed)

Edited by Stan Hu

Merge request reports