On Fri, Dec 17, 2010 at 5:10 AM, Michael Bayer <mike...@zzzcomputing.com> wrote: >> A major part of development resources as of late have been focused on add() >> and cascade_iterator(). I would advise trying out the 0.7 tip from >> mercurial where we've cut out a lot of overhead out of many areas of the >> flush including add() + cascade_iterator (see >> http://techspot.zzzeek.org/2010/12/12/a-tale-of-three-profiles/ for some >> profiling output).
That's great news! I'll give 0.7 a try, thanks for the heads up. >> Things like inlining Session.__contains__ are good ideas if they are shown >> to be prominent in a slow profile, so if you want to send along a test >> script to me that illustrates your bottlenecks I can work on its pain points >> and add it to our suite. Thanks for your offer, I might just take you up on that. Reducing my app to a test case without sending you any of my customer's data might be tricky though so I'll see how I go with 0.7 first. > I uploaded runsnakerun details from add() + cascade_iterator for current > 0.6.6 and 0.7 tips, which is against the test program run in that post. Its > a total of 11,000 add() calls. 0.7 is on the top. 0.7's larger percentage > overall is due to performance increases elsewhere. The fact that its a > lower percentage than your case is probably due to the lower number of > relationships() in the test script, since cascade_iterator() increases in > time for each relationship. Interesting. By the way, in case you didn't know it gprof2dot is another nice way of visualizing cProfiler output. It doesn't convey relative percentages as well as runSnakeRun does but has the advantage of better visualizing the call graph. http://code.google.com/p/jrfonseca/wiki/Gprof2Dot -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
