yahoo-eng-team team mailing list archive

[Pavlo Shchelokovskyy <1775207@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

While fixing bug 1582585 the change
I2c266e91f2f05be760f8a3eea3738868243cc9c6 started fetching all mappings
from SQL and performing in-memory joins.

However, with many users and groups mappings such fetching may become
too slow -  for instance, with ~125k users CLI command "openstack domain
list" takes up to 7 seconds and login to the Horizon - up to 20 seconds.

Additionally filtering the corresponding query in
get_domain_mapping_list method by entity_type speeds up things somewhat.

** Affects: keystone
     Importance: Undecided
     Assignee: Pavlo Shchelokovskyy (pshchelo)
         Status: In Progress

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1775207

Title:
  Fetching all mappings may become too slow

Status in OpenStack Identity (keystone):
  In Progress

Bug description:
  While fixing bug 1582585 the change
  I2c266e91f2f05be760f8a3eea3738868243cc9c6 started fetching all
  mappings from SQL and performing in-memory joins.

  However, with many users and groups mappings such fetching may become
  too slow -  for instance, with ~125k users CLI command "openstack
  domain list" takes up to 7 seconds and login to the Horizon - up to 20
  seconds.

  Additionally filtering the corresponding query in
  get_domain_mapping_list method by entity_type speeds up things
  somewhat.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1775207/+subscriptions