Performance of GetAllProjects with pagination

[niraymak]

Describe the bug
Using the pagination in the project overview page is very slow.

To Reproduce
Steps to reproduce the behavior:

1. https://staging.dex.software/project/overview
2. Page 2 at the bottom of the page.
3. Use Chrome DevTools to track performance of query.

Expected behavior
Should be way faster.

Screenshots
1.6s to load the project overview page 2.

Production URL
https://staging.dex.software/project/overview

Additional context
It looks like awesome dot net has something to do with it. https://staging.dex.software/project/details/1-awesome-dotnet

However, this project slows the performance on staging but not on production.

[niraymak]

Tested on my local machine on with develop branch.
Only the first time it was >1000ms. After that it was around 200ms.

Switched amountOnPage parameters. https://api.staging.dex.software/api/project?page=1&amountOnPage=22&sortBy=updated&sortDirection=desc
I did increase by one till I saw the performance dropping and mentioned that it dropped when I increased from 21 to 22. Look like it has something to do with this project: https://staging.dex.software/project/details/1-awesome-dotnet

[niraymak]

Tested on my local machine on with develop branch.
Only the first time it was >1000ms. After that it was around 200ms.

Switched amountOnPage parameters. https://api.staging.dex.software/api/project?page=1&amountOnPage=22&sortBy=updated&sortDirection=desc
I did increase by one till I saw the performance dropping and mentioned that it dropped when I increased from 21 to 22. Look like it has something to do with this project: https://staging.dex.software/project/details/1-awesome-dotnet

The database in production has the same project. https://dex.software/project/details/85-awesome-dotnet
This project is included in the following query: https://api.dex.software/api/project?page=2&amountOnPage=12&sortBy=updated&sortDirection=desc and is much faster.

[niraymak]

Applied this https://stackoverflow.com/a/40183279 to our GetAllWithUsersAndCollaboratorsAsync method in the project repo.

Performance increased from 850-1000ms to 200-350ms.

[niraymak]

Applied this https://stackoverflow.com/a/40183279 to our GetAllWithUsersAndCollaboratorsAsync method in the project repo.

Performance increased from 850-1000ms to 200-350ms.

After deleting awesome dot net the performance even increased to 100-200ms.