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
  16. listZones
  17. listDiskOfferings
  18. listServiceOfferings
• 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.