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)
Reviewed: https:/ /review. opendev. org/685135 /git.openstack. org/cgit/ openstack/ manila/ commit/ ?id=462b0e7461c dd00d51f15aacaa 43854aeb0689f4
Committed: https:/
Submitter: Zuul
Branch: stable/stein
commit 462b0e7461cdd00 d51f15aacaa4385 4aeb0689f4
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)
Closes-bug: #1795463
(cherry picked from commit 57edcbd1da4b61c