** Also affects: ovsdbapp Importance: Undecided Status: New -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/2092133
Title: api slow due to missing LRP index Status in neutron: In Progress Status in ovsdbapp: New Bug description: With many routers/Logical_Router_Ports the neutron-api can get slow at scale. When profiling the api we noticed that much time gets spend in functions like: sync_routers_and_rports -> _is_router_port_changed schedule_unhosted_gateways -> get_unhosted_gateways -> get_gateway_chassis_binding schedule_unhosted_gateways -> get_gateway_chassis_az_hints This happens due to LRP queries without an index: lrp = idlutils.row_by_value(self.idl, 'Logical_Router_Port', 'name', gateway_name) After adding an Logical_Router_Port name index the API performance improves a lot. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/2092133/+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