DB profiling at scale

Registered by dan wendlandt on 2012-10-31

the DB model shared by most plugins changed significantly in Folsom, and we do not have much visibility into how this performs at scale, and whether there are additional indices needed for CRUD operations to be available when there are 10s of thousands of entities in the DB.

Blueprint information

Status:
Complete
Approver:
Mark McClain
Priority:
Medium
Drafter:
Salvatore Orlando
Direction:
Needs approval
Assignee:
None
Definition:
Obsolete
Series goal:
None
Implementation:
Not started
Milestone target:
None
Completed by
Armando Migliaccio on 2015-11-21

Related branches

Sprints

Whiteboard

Nov-20-2015(armax): If someone is interested in pursuing it, this must be re-submitted according to guidelines defined in [1].

[1] http://docs.openstack.org/developer/neutron/policies/blueprints.html

-----------------

moving out of Grizzly because of time constraints and lack of interest from other devs to actively work
I will take care of this BP
Edgar Magana (emagana)

---
Does somebody works on this? We could help in IceHouse with this stuff -- boris-42 ()

(?)

Work Items

Work items:
Fix bug 1160333 "N+1 DB queries executed when extra_route extension is enabled": INPROGRESS
Design a solution for model base which complements orm.relationship and utilize joined loads (via filter hooks): TODO

This blueprint contains Public information 
Everyone can see this information.