Pagination does not speed up list queries for share network and security service operations

[Carlos Eduardo]

The pagination is slow for some operations in Manila. It happens when an administrator has a busy environment with a great amount of resources.

The affected operations are:
  - Share network list
  - Security service list

Steps:
  - Create more than 400 items for each one of the above mentioned resources.
  - List the resources for one of the above mentioned items using '--limit 10'

After the list command, the results for this operation should take few seconds to be returned, but actually, it spends at least 20 seconds.

As realized in the code investigation and changes proposed for similar problems [1] [2], the solution for this bug will require a bigger refactoring effort than the proposed in [3].

[1] https://bugs.launchpad.net/manila/+bug/1831094
[2] https://bugs.launchpad.net/manila/+bug/1795463
[3] https://review.opendev.org/#/c/650986/

[Jason Grosso (jgrosso)]

Carlos, I see that this defect is tied to https://bugs.launchpad.net/manila/+bug/1831094 and the checked-in fix https://review.opendev.org/#/c/650986/ may require some more effort than you expected is there anything you need help with? I can rough some people up or yell at them :) if need be !

[Carlos Eduardo (silvacarlose)]

Hi, Jason! Yes, it is related to the bug you just added the link. It will require a bit more of effort because manila does the same for those operations but in different ways. In the bug you just mentioned, the fix is quite similar to the one that is already merged and backported. But for this case, some things will be modified. I think I can handle with it when I have some time and I intend to work on a fix for this bug. Thank you so much for the support :)