| API | Parameters | Time taken for getting the complete response | Comments | |||
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 Domain 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: 200 2000 |
| ||||||
|
|
|
| listProjectInvitations | listAll=true&pagesize=100&page=1 | 0m0.129s | Returned 100 objects |
| listProjectInvitations | listAll=true&pagesize=100800&page=1 |
| 0m0.515s | Returned 800 objects Fails with NPE | ||
| 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