yahoo-eng-team team mailing list archive

[jackning <ningyougang@xxxxxxxxxxxxx>]

Public bug reported:

In our project,we found that the speed of query user from ldap server
was very slow(our ldap user number is 12,000,the query costs almost 45
seconds)

The reason is that keystone will generate the uuid for the ldap users one by one and insert db.
And second time query,it also goes to db,not use the cache to improve the speed.

So we can add the cache to improve the query speed
After add @MEMOIZE to the following function
https://github.com/openstack/keystone/blob/master/keystone/identity/core.py#L580,
first query time almost costs 50 seconds,but second time leter only costs 7 seconds.

So i think it is very nessary to improve this feature

** Affects: keystone
     Importance: Undecided
     Assignee: jackning (ningyougang)
         Status: New

** Changed in: keystone
     Assignee: (unassigned) => jackning (ningyougang)

** Description changed:

  In our project,we found that the speed of query user from ldap server
  was very slow(our ldap user number is 12,000,the query costs almost 45
  seconds)
  
  The reason is that keystone will generate the uuid for the ldap users one by one and insert db.
  And second time query,it also goes to db,not use the cache to improve the speed.
  
  So we can add the cache to improve the query speed
  After add @MEMOIZE to the following function
  https://github.com/openstack/keystone/blob/master/keystone/identity/core.py#L580,
  the query costs 7 seconds,but first query almost costs 50 seconds
+ 
+ So i think it is very nessary to improve this feature

** Description changed:

  In our project,we found that the speed of query user from ldap server
  was very slow(our ldap user number is 12,000,the query costs almost 45
  seconds)
  
  The reason is that keystone will generate the uuid for the ldap users one by one and insert db.
  And second time query,it also goes to db,not use the cache to improve the speed.
  
  So we can add the cache to improve the query speed
  After add @MEMOIZE to the following function
  https://github.com/openstack/keystone/blob/master/keystone/identity/core.py#L580,
- the query costs 7 seconds,but first query almost costs 50 seconds
+ first query time almost costs 50 seconds,but second time leter only costs 7 seconds.
  
  So i think it is very nessary to improve this feature

-- 
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/1582585

Title:
  the speed of query user from ldap server is very slow

Status in OpenStack Identity (keystone):
  New

Bug description:
  In our project,we found that the speed of query user from ldap server
  was very slow(our ldap user number is 12,000,the query costs almost 45
  seconds)

  The reason is that keystone will generate the uuid for the ldap users one by one and insert db.
  And second time query,it also goes to db,not use the cache to improve the speed.

  So we can add the cache to improve the query speed
  After add @MEMOIZE to the following function
  https://github.com/openstack/keystone/blob/master/keystone/identity/core.py#L580,
  first query time almost costs 50 seconds,but second time leter only costs 7 seconds.

  So i think it is very nessary to improve this feature

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