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 : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
