Nova API in Horizon sometimes act as a bottleneck

not very familiar with horizon, but If I understand it correctly, you want nova to return the instances and do the query in horizon side , instead , specify some options to nova and ask nova to query ?

there is a 'search option' but your request may not be there currently ... wait for response and wait for more confirm

Yes, it is correct: instead of querying Nova for _all_ existing instances and then picking the required ones at Horizon side, I'd rather specify in request to Nova which instances exactly (preferably by `instance_id`) I need in Horizon.

there is a rule that API changes need a spec
let me draft one and see someone has opinion and sugestions, will paste the link here later

Okay, thank you very much for the efforts! Looking forward to the spec :).

I dig into code more and got several questions:

1) seems the logic of horizon is get volumes and instances then use local loop
if we offer an option to search, e.g filter instances by each volume ,should this increase the
REST API request and db hit? maye performance is not that good?

2) Also, seems the attach detach info is recorded at cinder db ,should it be better to
submit this to cinder instead of nova ?

both apply to 2nd question on floating IP, thanks

Sorry for the long time it took me to answer, I was being distracted by other tasks. So, regarding you you questions...

1. The data received from Cinder already contains instance ids. The only reason Horizon does a separate call to Nova is that he needs to get these instances' names (and possibly some other metadata). Asking the Nova to filter the instance list by volumes seems like a duplication of work to me ('cause we already know these instances), passing just instance ids would suffice.

2. Most likely Cinder doesn't know about instances' names, that's why Horizon does a request to Nova. This architecture is okay IMO, because each OpenStack component should do its _own_ job, with Horizon aggregating the data across many components just for the user's convenience.

Fix proposed to branch: master
Review: https://review.openstack.org/213260

Reviewed: https://review.openstack.org/213260
Committed: https://git.openstack.org/cgit/openstack/horizon/commit/?id=ed076e623458467c9dc4f2a9f49f3abb8466d562
Submitter: Jenkins
Branch: master

commit ed076e623458467c9dc4f2a9f49f3abb8466d562
Author: Timur Sufiev <email address hidden>
Date: Fri Aug 14 20:20:45 2015 +0300

    Do not make unnecessary calls to Nova from FIPs and Volumes tabs

    If none of the floating IPs listed within Horizon are attached to an
    instance, do not request a list of Nova instances (because we have no
    use for it). Apply the same behavior for Volumes tab (both Admin and
    Project). This patch both saves us from making unnecessary and
    potentially expensive call to Nova and lays the ground for a more
    selective request of instance details from Nova. The latter will be
    possible once Nova supports filtering instance details by >1
    instance_id. For reference see
    https://blueprints.launchpad.net/nova/+spec/get-multi-servers-filter

    Change-Id: Ie7563b9e03b286b4cf51507463213162af3383b1
    Partial-Bug: #1442310

What would the impact be to actually do the GET /servers/{id} when needed here? That's the thing I don't understand or see the implications of.

@sergey are you working on this bug? If so please mark it as "in progress" otherwise if you do not have any plans to work on it anytime soon, please assign the ticket to 'nobody'. Thanks

Removing assignee due to lack of visible progress for a period of over one month.