Comment 32 for bug 1810563

Reviewed: https://review.opendev.org/650525
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=d075028146a6fcec57e05fc4952682bb2ad49b58
Submitter: Zuul
Branch: stable/queens

commit d075028146a6fcec57e05fc4952682bb2ad49b58
Author: Doug Wiegley <email address hidden>
Date: Sun Mar 3 10:42:16 2019 -0700

    Use dynamic lazy mode for fetching security group rules

    In conjunction with the prior fix to only get a subset of fields
    when needed, this makes the querying of non-rules SG objects
    very very fast.

    Before the two fixes, if you have about ten security groups with 2000 rules each:

    list all: 14s
    list all, just 'id' field: 14s
    list one: 0.6s
    list one, just 'id' field: 0.6s

    With just the previous partial fix:

    list all: 14s
    list all, just 'id' field: 6s
    list one: 0.6s
    list one, just 'id' field: 0.2s

    Now with this change:

    list all: 14s
    list all, just 'id' field: 0.04s
    list one: 0.6s
    list one, just 'id' field: 0.03s

    Closes-Bug: #1810563
    Change-Id: I15df276ba7dbcb3763ab20b63b26cddf2d594954
    (cherry picked from commit 1e9086f6e269f32d1cb19a0f55eb1f5dd73ca651)