Page History

...

• Created DB views to further speed up the following costly list APIs:
  1. listAccounts
  2. listAsyncJobs
  3. listDomainRouters
  4. listEvents
  5. listHosts
  6. listVmGroups
  7. listProjects
  8. listProjectAccounts
  9. listProjectInvitations
  10. listResourceTags
  11. listSecurityGroups
  12. listUsers
  13. listVirtualMachines
  14. listVolumes
  15. listStoragePools
• Added a new create-schema-view.sql to create these new DB views during database setup phase.
• Also handled upgrade script for these new DB views in schema-40to410.sql.