1. listAccounts API: Total # of accounts: 4000

 

 

 

listAccounts

listAll=true&pagesize=100

0m16.923s

Returned 100 objects

 

listAccounts

listAll=true&pagesize=800

0m26.555s

Returned 800 objects

 

listAccounts

listAll=true&pagesize=1500

0m40.140s

Returned 1500 objects

 

listAccounts

listAll=true&pagesize=3000

1m3.906s

Returned 3000 objects

 

listAccounts

listAll=true

1m25.348s

Returned all 4K objects

2. listRouters API: Total # of Virtual Routers: 8000
(Including all RVRs)

 

 

listRouters

listAll=true&pagesize=100&page=1

0m2.398s

Returned 100 objects

 

listRouters

listAll=true&pagesize=800&page=1

0m10.372s

Returned 800 objects

 

listRouters

listAll=true&pagesize=1500&page=1

0m20.857s

Returned 1500 objects

 

listRouters

listAll=true&pagesize=3000&page=1

0m35.034s

Returned 3000 objects

 

listRouters

listAll=true&pagesize=5000&page=1

1m0.932s

Returned 5000 objects

 

listRouters

listAll=true

1m30.935s

Returned all 8k objects

3. listEvents API: Total # of Events in DB: 8000

 

 

listEvents

listAll=true&pagesize=100&page=1

0m5.967s

Returned 100 objects

 

listEvents

listAll=true&pagesize=800&page=1

0m3.006s

Returned 800 objects

 

listEvents

listAll=true&pagesize=1500&page=1

0m2.111s

Returned 1500 objects

 

listEvents

listAll=true&pagesize=3000&page=1

0m4.122s

Returned 3000 objects

 

listEvents

listAll=true&pagesize=5000&page=1

0m6.575s

Returned 5000 objects

 

listEvents

listAll=true

0m15.399s

Returned all 8k objects

4. listHosts API: Total # of Hosts: 1794

 

 

listHosts

listAll=true&pagesize=100&page=1

0m1.906s

Returned 100 objects

 

listHosts

listAll=true&pagesize=800&page=1

0m13.316s

Returned 800 objects

 

listHosts

listAll=true&pagesize=1500&page=1

0m27.115s

Returned 1500 objects

 

listHosts

listAll=true

0m31.509s

Returned all 1986 objects

5. listUsers API: Total # of Users: 4001

 

 

listUsers

listAll=true&pagesize=100&page=1

0m0.253s

Returned 100 objects

 

listUsers

listAll=true&pagesize=800&page=1

0m2.105s

Returned 800 objects

 

listUsers

listAll=true&pagesize=1500&page=1

0m2.485s

Returned 1500 objects

 

listUsers

listAll=true&pagesize=3000&page=1

0m6.975s

Returned 3000 objects

 

listUsers

listAll=true

0m6.787s

Returned all 4k objects

6. listVirtualMachines API: Total # of User VMs: 4000

 

 

listVirtualMachines

listAll=true&pagesize=100&page=1

0m1.671s

Returned 100 objects

 

listVirtualMachines

listAll=true&pagesize=800&page=1

0m9.191s

Returned 800 objects

 

listVirtualMachines

listAll=true&pagesize=1500&page=1

0m13.068s

Returned 1500 objects

 

listVirtualMachines

listAll=true&pagesize=3000&page=1

0m22.950s

Returned 3000 objects

 

listVirtualMachines

listAll=true

0m35.443s

Returned all 4K objects

7. listVolumes API: Total # of User Volumes: 3299

 

 

listVolumes

listAll=true&pagesize=100&page=1

0m0.830s

Returned 100 objects

 

listVolumes

listAll=true&pagesize=800&page=1

0m3.900s

Returned 800 objects

 

listVolumes

listAll=true&pagesize=1500&page=1

0m5.887s

Returned 1500 objects

 

listVolumes

listAll=true&pagesize=3000&page=1

0m11.037s

Returned 3000 objects

 

listVolumes

listAll=true

0m18.859s

Returned all 4K objects

8. listStoragePools API: Total # of Storage pools: 224

 

 

listStoragePools

listAll=true&pagesize=100&page=1

0m0.313s

Returned 100 objects

 

listStoragePools

listAll=true

0m0.454s

Returned all 224 objects

9. listProjects API: Total # of Projects: 4000

 

 

listProjects

listAll=true&pagesize=100&page=1

0m0.304s

Returned 100 objects

 

listProjects

listAll=true&pagesize=800&page=1

0m1.019s

Returned 800 objects

 

listProjects

listAll=true&pagesize=1500&page=1

0m1.696s

Returned 1500 objects

 

listProjects

listAll=true&pagesize=3000&page=1

0m2.986s

Returned 3000 objects

 

listProjects

listAll=true

0m5.213s

Returned all 4K objects

10. listProjectAccounts API

 

 

listProjectAccounts

listAll=true&projectid=3

0m33.247s

Returned 4000 objects, project has 4000 accounts

 

listProjectAccounts

listAll=true&projectid=4

0m15.992s

Returned 2000 objects, Project has 2000 accounts

11. listProjectInvitations API: Total # of Projects: 2000

 

 

listProjectInvitations

listAll=true&pagesize=100&page=1

0m0.129s

Returned 100 objects

 

listProjectInvitations

listAll=true&pagesize=800&page=1

0m0.515s

Returned 800 objects

 

listProjectInvitations

listAll=true

0m0.843s

Returned all 2K objects

12. listAsyncJobs API: Total # of Async Jobs: 12000

 

 

listAsyncJobs

listAll=true&pagesize=100&page=120

0m0.544s

Returned 100 objects

 

listAsyncJobs

listAll=true&pagesize=800&page=5

0m8.027s

Returned 800 objects

 

listAsyncJobs

listAll=true&pagesize=1500&page=6

0m1.856s

Returned 1500 objects

 

listAsyncJobs

listAll=true&pagesize=3000&page=3

0m3.396s

Returned 3000 objects

 

listAsyncJobs

listAll=true&pagesize=8000&page=1

0m7.731s

Returned 8000 objects

 

listAsyncJobs

listAll=true

0m9.139s

Returned all 12K objects

13. listTags API: Total # of Tags created: 3845

 

 

listTags

listAll=true&pagesize=100&page=1

0m0.306s

Returned 100 objects

 

listTags

listAll=true&resourcetype=UserVm

0m1.023s

Returned 2563 objects

 

listTags

listAll=true&resourcetype=Volume

0m0.704s

Returned 1282 objects

 

listTags

listAll=true&key=<somekey>

0m0.469s

Returned 20 objects

 

listTags

listAll=true&resourcetype=Volume&key=<somekey>

0m0.113s

Returned 10 objects

 

listTags

listAll=true&resourcetype=Volume&value=<somekey>

0m0.113s

Returned 10 objects

 

listTags

listAll=true

0m2.048s

Returned all 2K objects

14. listProjects API: Total # of Projects: 4000

 

 

listInstanceGroups

listAll=true&pagesize=100&page=1

0m0.978s

Returned 100 objects

 

listInstanceGroups

listAll=true&pagesize=800&page=1

0m0.504s

Returned 800 objects

 

listInstanceGroups

listAll=true&pagesize=1500&page=1

0m0.737s

Returned 1500 objects

 

listInstanceGroups

listAll=true&pagesize=3000&page=1

0m0.573s

Returned 3000 objects

 

listInstanceGroups

listAll=true

0m4.243s

Returned all 4K objects

14. listSecurityGroups API: Total # of SecGroups: 4000

 

 

listSecurityGroups

listAll=true&pagesize=100&page=1

0m9.681s

Returned 100 objects

 

listSecurityGroups

listAll=true&pagesize=800&page=1

0m12.481s

Returned 800 objects

 

listSecurityGroups

listAll=true&keyword=<somekeyword>

0m7.411s

Returned 1111 objects

 

listSecurityGroups

listAll=true&pagesize=1500&page=1

0m16.394s

Returned 1500 objects

 

listSecurityGroups

listAll=true&pagesize=3000&page=1

0m20.719s

Returned 3000 objects

 

listSecurityGroups

listAll=true

0m26.439s

Returned all 4K objects

RESULT:

For all APIs, the response time is within 2 mins for a max of 4K objects. In comparison with the baseline numbers, the above results look good.

UPGRADE:

Performed upgrade from 4.0 to 4.1 and verified that schema of views from fresh install matched that of upgraded schema for the following views concerning the optimizationaccount_netstats_view

account_view

account_vmstats_view

async_job_view

data_center_view

disk_offering_view

domain_router_view

event_view

free_ip_view

host_view

instance_group_view

project_account_view

project_invitation_view

project_view

resource_tag_view

security_group_view

service_offering_view

storage_pool_view

user_view

user_vm_view

volume_view

  • No labels