Bug: /project/children endpoint is slow

[MichaelAkvo]

What were you doing?

When accesing the hierarchies view for EUTF Africa, the program has 265 child projects and it takes about 20s to load them all. /project/children is a paged call and has to be called multiple times to get all children. Each call takes bout 2s.

What should've happened?

Each call should really only take a 10s of milliseconds not thousands.

My environment

No response

Additional context

The frontend also doesn't add the projects as they arrive, instead it waits for all calls to complete. Another bug report should probably be created.