On Tuesday 10 June 2008 22:13:04 Artur Siekielski wrote: > On Jun 10, 8:11 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > > I would first take a look at the SQL > > being issued as the first source of speed differences; if in > > 0.4.5 there's suddenly a whole series of deletes occuring which > > do not within 0.4.4, then that's the source of the difference. > > SQL is the same. These differences are also when I don't flush the > Session. Also performance when not using Psyco is the same in 0.4.4 > and 0.4.5. But switching Psyco on in 0.4.4 causes 50% performance > increase and in 0.4.5 about 1000% decrease.
well.. see the difference, the function that eats the time is sql.sort_tables. all else is nearly same. compare the two sources and see for yourself. the sort_tables() itself seems same, but traversing (recursive) has changed a lot. from depth first into breadth first or similar. something is going on there. AFAIremember psyco can optimize loops and arithmetics but is very bad with func-calls. profile both versions of that function without psyco and see what's difference in funccalls etc. ciao svilen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
