[sqlalchemy] Re: Long transactions with SQLite (and of course locks)

2015-04-01 Thread Eric Smith
Thanks for the comment. If I understand you correctly, I'm going in a similar direction in trying to keep transactions short. If there is a write to the database, I want a commit or rollback shortly thereafter (usually on the order of milliseconds rather than anywhere approaching the 5 second t

[sqlalchemy] Re: Long transactions with SQLite (and of course locks)

2015-04-01 Thread Jonathan Vanasco
On a sidenote, I found the best approach to a similar problem (which used Twisted) was to make the transactions as short as possible. Three hours of changing how transactions were used was far more helpful than 2 weeks of trying to get around long transactions. -- You received this message be