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 |
|
|||
|
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