Nicolas Vazquez created CLOUDSTACK-9340:
-------------------------------------------
Summary: General DB Optimization
Key: CLOUDSTACK-9340
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9340
Project: CloudStack
Issue Type: Improvement
Security Level: Public (Anyone can view this level - this is the default.)
Affects Versions: 4.9.0
Reporter: Nicolas Vazquez
Fix For: 4.9.0
h2. General DB Optimization
In some production environments there were being experimented delays in most of
the jobs. A search for DB optimization was taken and some deficiencies were
discovered, we can group them in 4 groups:
* Incorrect PRIMARY key
* Duplicate PRIMARY KEY
* Missing indexes (Add indexes to avoid full table scans)
* Some views query (Change view to improve account retrieval speed)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
