yahoo-eng-team team mailing list archive

[Joe Gordon <1212418@xxxxxxxxxxxxxxxxxx>]

with the addition of Mike Bayer (sqlalchemy developer), it looks like
there is hope for us on this one.

** Changed in: nova
       Status: Confirmed => Opinion

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1212418

Title:
  SQLAlchemy performs poorly on large result sets

Status in OpenStack Compute (Nova):
  Opinion

Bug description:
  I'm not exactly sure what the interaction is that causes this problem,
  but it is evidenced very nicely by calling compute_node_get_all. While
  the MySQL query returns this data in about 2 seconds, it takes another
  53 seconds for SQLAlchemy to shove all those results into a list.

  Here's the script being run:

  http://paste.openstack.org/show/44079/

  Here are results:

  http://paste.openstack.org/show/44143/

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1212418/+subscriptions