[sqlalchemy] Re: SQLAlchemy getting slow when do a lots of things in transaction

I found that it seems not the transaction cause the performance problem. I think it maybe cause by use one session for a long time. Performance getting slower with the program run longer time. Once I stop the program and run it again, at first it works fast. So I think it is the problem of using

[sqlalchemy] Re: SQLAlchemy getting slow when do a lots of things in transaction

On Aug 18, 2008, at 1:02 PM, Victor Lin wrote: I found that it seems not the transaction cause the performance problem. I think it maybe cause by use one session for a long time. Performance getting slower with the program run longer time. Once I stop the program and run it again, at

[sqlalchemy] Re: SQLAlchemy getting slow when do a lots of things in transaction

Finally, I found the real reason of performance problem. There is a pickle filed in my table. SQLAlchemy update all rows every query. That's why it is so slow. By following the guide of FAQ, I have solved that problem. Thanks your help. Victor Lin. On 8月19日, 上午1時16分, Michael Bayer [EMAIL