[CLOUDSTACK-9340] General DB Optimization

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.9.0
• Fix Version/s: 4.9.0
• Security Level: Public (Anyone can view this level - this is the default.)
• Labels: database
• Flags: Patch
• Assignee: Nicolas Vazquez
• Reporter: Nicolas Vazquez
• Created: 07/Apr/16 15:33
• Updated: 29/Dec/17 02:16
• Resolved: 17/May/16 06:23

Description

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)