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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp

