Re: [sqlalchemy] Re: Slow commit after large select

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 commit Are there foreign key checks involved with the commit? Yep When I set up

[sqlalchemy] Re: Slow commit after large select

It's hard to tell what could cause the issue: How many horses are there? What is going on in that other function? Are there foreign key checks involved with the commit? If you want to break a huge batch into smaller commits, there is the `Windowed Range Query` strategy -- https://bitbucket.org/