On Friday 23 October 2009 08:07:24 Marko Springfeldt wrote: > Gaetan de Menten schrieb: > > On Thu, Oct 22, 2009 at 19:48, Diez B. Roggisch <[email protected]> wrote: > >> a couple of month ago I asked how to create circular dependencies within > >> Elixir. Eventually, I dropped the issue, as I just created a normal > >> int-column and some @property-magic around it. > >> > >> Now it became apparent that this produces *horrible* SQL-query-numbers, > >> as SA/Elixir isn't aware of the relationship. > >> > >> We found that by temporarily declaring the relationship the other way > >> round, and it massively improved the performance. > >> > >> So I created a minimal example that shows the problems we run into - and > >> it would be *fabulous* if one could advise us on how to solve that. > > > > You should use post_update=True on the ManyToOne relationship. See: > > http://www.sqlalchemy.org/docs/05/mappers.html#rows-that-point-to-themsel > >ves-mutually-dependent-rows > > Elixir has build in versioning system. > http://elixir.ematia.de/apidocs/elixir.ext.versioned.html > Here are some nice slides containing also some examples on other > extensions in elixir. > http://cleverdevil.org/elixirtalk/slides.pdf
Cool, and certainly interesting - but not really applying to our actual problem (which the example was a strip-down of) Thanks, Diez --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" 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/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
