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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp