Public bug reported: When our keystone to valid token , it cost too much time on function check_revocation.
In the path /keystone/revoke/backends/sql.py func list_events() > events = [revoke_model.RevokeEvent(**e.to_dict()) for e in query] It cost about 3 second and our database on revocation_event table has 38596 row. Query sql from this table cost 0.01 second,but transfer this to a dict cost 3s. --------------- mysql> select count(*) from revocation_event; +----------+ | count(*) | +----------+ | 38596 | +----------+ ** Affects: keystone Importance: Undecided Status: New -- 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/1634746 Title: check revocation too slow Status in OpenStack Identity (keystone): New Bug description: When our keystone to valid token , it cost too much time on function check_revocation. In the path /keystone/revoke/backends/sql.py func list_events() > events = [revoke_model.RevokeEvent(**e.to_dict()) for e in query] It cost about 3 second and our database on revocation_event table has 38596 row. Query sql from this table cost 0.01 second,but transfer this to a dict cost 3s. --------------- mysql> select count(*) from revocation_event; +----------+ | count(*) | +----------+ | 38596 | +----------+ To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/1634746/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp