Slow Namespace#all_projects

The Namespace#all_projects method performance was previously improved when used with linear queries. A subsequent MR revert removed the fix from !62268 (merged).

We need to re-instate the call to self_and_descendant_ids over the self_and_descendants call.