Multiple times retrieve information of project_id in Delete domain

[lucky]

In Delete domain usecase, Redundant SQL queries are getting executed, which can lead to performance delay.
In Delete domain use case, select query is executed multiple times to retrieve information of project_id. This must be reduced to enhance the performance.

Code change is required for handling the redundant SQL queries.
There is a need to change the code in keystone/token/backends.sql.py so that the extra queries will be removed.

[Lance Bragstad (lbragstad)]

Thanks for the bug report. I can imagine there is some duplication here. Did you use a tool or have specific steps to determine the redundancies?

Setting the priority here to Low since a common workaround is to enable caching.

[lucky (luckysingh)]

@lance Bragstad : I have enabled mysql logs and then verified it.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/589027

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/589027
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=44da48f013881e87f8ac099cf7462d00d804ddd3
Submitter: Zuul
Branch: master

commit 44da48f013881e87f8ac099cf7462d00d804ddd3
Author: wangxiyuan <email address hidden>
Date: Mon Aug 6 15:05:25 2018 +0800

    Remove redundant get_project call

    This patched removed some redundant "get_project" calls when
    deleting projects/domains.

    Change-Id: Ife4dd18962077bac30fa1cecf7621cc86a62929c
    Closes-bug: #1764282

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/keystone 15.0.0.0rc1 release candidate.