Multiple times retrieve information of project_id in Delete domain
Bug #1764282 reported by
lucky
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Identity (keystone) |
Fix Released
|
Low
|
wangxiyuan |
Bug Description
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/
summary: |
- Mutilple times retrieve information of project_id in Delete domain + Multiple times retrieve information of project_id in Delete domain |
tags: | added: sql |
Changed in keystone: | |
assignee: | nobody → wangxiyuan (wangxiyuan) |
Changed in keystone: | |
milestone: | none → rocky-rc1 |
To post a comment you must log in.
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.