Public bug reported: Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource per tenant.
Simple example with adding index on securitygrouprules show that speed could increase twice. For MySQL http://paste.openstack.org/show/169810/ For PostgreSQL http://paste.openstack.org/show/169957/ ** Affects: neutron Importance: Undecided Status: New ** Tags: db -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1419815 Title: Speed up SELECTs with filters by tenant_id Status in OpenStack Neutron (virtual network service): New Bug description: Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource per tenant. Simple example with adding index on securitygrouprules show that speed could increase twice. For MySQL http://paste.openstack.org/show/169810/ For PostgreSQL http://paste.openstack.org/show/169957/ To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1419815/+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
