Yannick Gingras wrote: > On December 11, 2009, Michael Bayer wrote: >> are you on 0.5.6 ? major speed issues related to flush() were >> repaired around 0.5.4 or so. > > I was on 0.5.2. After upgrading, I get roughly the same timing total > duration but object creation is slightly faster and commit is slightly > slower. The overall difference is less then 10%.
150K is an enormous amount to send through the ORM. you probably want to at least call flush() every 1000 objects or so to reduce the size of each flush plan - allocating memory for a 150K dependency tree alone is probably taking a significant amount of time. > > -- > Yannick Gingras > http://ygingras.net > http://confoo.ca -- track coordinator > http://montrealpython.org -- lead organizer > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
