Public bug reported:

Now there is not any index for port  DB sqlalchemy, but for nova bulk create 
VM, it frequently select port according to 'tenant_id','network_id' 
,'device_id', if no index, it will consume much time in db operation, so I 
think it is better to add index for
port 'tenant_id','network_id' ,'device_id'

** Affects: neutron
     Importance: Undecided
     Assignee: shihanzhang (shihanzhang)
         Status: New

** Changed in: neutron
     Assignee: (unassigned) => shihanzhang (shihanzhang)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1421089

Title:
  no any index for port DB sqlalchemy

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Now there is not any index for port  DB sqlalchemy, but for nova bulk create 
VM, it frequently select port according to 'tenant_id','network_id' 
,'device_id', if no index, it will consume much time in db operation, so I 
think it is better to add index for
  port 'tenant_id','network_id' ,'device_id'

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1421089/+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

Reply via email to