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 Assignee: Ann Kamyshnikova (akamyshnikova) Status: New ** Tags: db ** Changed in: neutron Assignee: (unassigned) => Ann Kamyshnikova (akamyshnikova) -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1419816 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/1419816/+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
