Hi Bob Looks like you're doing some fun thinking :)
Steve On Thu, Aug 21, 2008 at 11:04 AM, Bob Farrell <[EMAIL PROTECTED]> wrote: > Hi there, > > I spoke with zzzeek_ on IRC yesterday re: some code I'd written for an > introspective cascading delete function. We were previously using the ORM to > do > this for us but, due to the way it works, it was taking several minutes to > delete large amounts of second-generation orphans. The code I've written > recursively gets all the tables involved, analyses the relationships and > issues > as few delete statements as possible (I hope). I've attached the code, or > there's a link to it here: > http://paste.pocoo.org/show/82878/ > > With parent->child relationships my tests are showing this working much, much > faster than the ORM (by a factor of at least 100x). I haven't had a chance to > set up more complicated tables to fully test the recursive aspect of it but it > has worked with what I've given it so far. > > I'm really enjoying working with SQLAlchemy, you guys have done a really good > job. If you think there's room for something like this in SA then it's all > yours. :-) > > Cheers, > -- > -------------------------- > Bob Farrell > pH, an Experian Company > www.phgroup.com > Office Line: 020 7598 0310 > Fax: 020 7598 0311 > -------------------------- > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---