Re: [sqlalchemy] Slow commit after large select

2015-02-07 Thread Ed Rahn
On 01/10/2015 04:04 PM, Michael Bayer wrote: Ed Rahn edsr...@gmail.com wrote: On 01/10/2015 01:51 PM, Jonathan Vanasco wrote: It's hard to tell what could cause the issue: How many horses are there? 463827 What is going on in that other function? Just a regex search, two selects and a

[sqlalchemy] Polymorphic adjacency lists and many-to-many

2015-02-07 Thread YKdvd
I have model FruitCategories which uses the bidirectional adjacency list pattern (Node) from the documentation. It is used to create a many-to-many connection to a model, say, Fruit, with an association table (fruits_cats), again vanilla like the docs. This all works great. I have other