Actually I have a question here, I see the main time consuming is commit.. But how to control the time to commit.
Because I don't know when request will come and how many requests will come, so seems my current code is to commit every engine.execute 在 2014年3月14日星期五UTC+8上午2时14分43秒，Jonathan Vanasco写道： > > Before writing stored procedures, you might want to test speeds like : > > 1. raw speed within the mysql client for these queries. > 2. speed of pushing these queries through your python dbapi driver ( ie, > mysqldb ) > > those should give you a better idea on where the potential speed problems, > if any are. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
