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)
Reviewed: https:/ /review. opendev. org/688542 /git.openstack. org/cgit/ openstack/ manila/ commit/ ?id=bad03feea9a 8470c9fe55f1a92 5d83e026353989
Committed: https:/
Submitter: Zuul
Branch: stable/rocky
commit bad03feea9a8470 c9fe55f1a925d83 e026353989
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)
Closes-bug: #1795463
(cherry picked from commit 57edcbd1da4b61c
(cherry picked from commit 462b0e7461cdd00