Front-end is not returning all the assets stored in the database

[JeffLabonte]

Describe the bug
I generated my inventory of cloud assets using Google Cloud Assets. I created a script that go fetch that inventory on Google Cloud and then insert them in CISO Assistant.

There are 3 problems:

• Not all the domains are returned
• Not all the assets are returned
• The query to fetch the inventory is really slow - More than 30 seconds for a request AT LEAST.

To Reproduce
Steps to reproduce the behavior:

1. Have more than 5000 assets in the inventory
2. Go to 'Organisation'
3. Click on 'Assets'
4. Wait while the backend process the requests
5. Enjoy the data you have available

Expected behavior

I expect to have a access to my different assets and to be able to link any of them in the risks.

Screenshots
If applicable, add screenshots to help explain your problem.

Environment (please complete the following information):
I tried on a lot of platform. I tried the community and the SaaS version of the app.

Additional context

IMO, you should call a different route to get all the domains and you should paginate your calls for real instead of building a JSON with the response.

[JeffLabonte]

I believe the slowness is caused by the link between the assets and the Risk Assessments.