Testing for Antelope using the same procedure as in the previous comment: Deployed a fresh openstack cloud and ran the timing performance script:
======================== Performance in virtually empty fresh cloud ======================== Time taken for network list: 1528 ms Time taken for security group list: 1334 ms Time taken for network rbac list: 1243 ms Time taken for network show: 1296 ms Used some scripts to create 10 networks, 10 security groups, 1000 projects, and 20000 RBAC rules sharing everything ======================== Performance of unpatched with 20000 RBAC rules ======================== Time taken for network list: 4735 ms Time taken for security group list: 3955 ms Time taken for network rbac list: 18564 ms Time taken for network show: 1367 ms Enabled Proposed: ======================== Performance of proposed with 20000 RBAC rules ======================== Time taken for network list: 2189 ms Time taken for security group list: 1605 ms Time taken for network rbac list: 13678 ms Time taken for network show: 1498 ms ----------------------------------------------- Testing on Yoga In a fresh openstack cloud ======================== Performance in virtually empty fresh cloud ======================== Time taken for network list: 1711 ms Time taken for security group list: 1718 ms Time taken for network rbac list: 1296 ms Time taken for network show: 1274 ms Created 10x Networks, 10x Security Groups, 1000x Projects, and created the rbac policies ======================== Performance of unpatched with 20000 RBAC rules ======================== Time taken for network list: 5223 ms Time taken for security group list: 5744 ms Time taken for network rbac list: 18511 ms Time taken for network show: 1782 ms ======================== Performance of proposed with 20000 RBAC rules ======================== Time taken for network list: 2228 ms Time taken for security group list: 2860 ms Time taken for network rbac list: 14086 ms Time taken for network show: 1645 ms ** Tags removed: verification-antelope-needed verification-yoga-needed ** Tags added: verification-antelope-done verification-yoga-done -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2092217 Title: [SRU] Missing Group-By Optimization Backport in Yoga and Antelope To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/2092217/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
