This patch modifies the database api layer to fix the pagination
slowness bug, which causes a delay while the administrator tries
to list shares using the `--limit` option.
This change was tested in a very busy environment with 800 shares.
Before the change, the operation took about 25 seconds to be
finished. Now, the operation takes about 3 seconds in the same
environment.
Change-Id: I89659452b0e033631f1318a2eabb7e120c9e5743
Closes-bug: #1795463
(cherry picked from commit 57edcbd1da4b61ce1a61db3be0d69755d968c36c)
(cherry picked from commit 462b0e7461cdd00d51f15aacaa43854aeb0689f4)
(cherry picked from commit bad03feea9a8470c9fe55f1a925d83e026353989)
Reviewed: https:/ /review. opendev. org/689604 /git.openstack. org/cgit/ openstack/ manila/ commit/ ?id=8263f911bea ef26865d30c2cfe e760c594175e5e
Committed: https:/
Submitter: Zuul
Branch: stable/queens
commit 8263f911beaef26 865d30c2cfee760 c594175e5e
Author: silvacarloss <email address hidden>
Date: Mon Apr 8 17:33:33 2019 -0300
Fix pagination does not speed up queries bug
This patch modifies the database api layer to fix the pagination
slowness bug, which causes a delay while the administrator tries
to list shares using the `--limit` option.
This change was tested in a very busy environment with 800 shares.
Before the change, the operation took about 25 seconds to be
finished. Now, the operation takes about 3 seconds in the same
environment.
Change-Id: I89659452b0e033 631f1318a2eabb7 e120c9e5743 e1a61db3be0d697 55d968c36c) d51f15aacaa4385 4aeb0689f4) c9fe55f1a925d83 e026353989)
Closes-bug: #1795463
(cherry picked from commit 57edcbd1da4b61c
(cherry picked from commit 462b0e7461cdd00
(cherry picked from commit bad03feea9a8470