On 10/26/06, Stuart Clarke <[EMAIL PROTECTED]> wrote: > > On Thu, 2006-10-26 at 09:20 +0100, Robin Haswell wrote: > > [EMAIL PROTECTED] wrote: > > > I think we need an optimizing sql compiler for tg. All my sqlobject > > > code is slow there is no turboboost switch. Its like my included > > > batteries are one shots. I need jumper cables over here. > > > > Sorry mate, SQLObject is slow by design. > > *** This is of great interest to me. Can someone explain the reason for > SO being slow? I'm using it in what will hopefully become a very > high-traffic site, and although I'm memcached-ing and squid-ing the hell > out of everything, this is still of great concern. > There's still a performance problem with Many-to-Many relationships, the default ones populate lists which has to fetch each object and it ends up being slow.
Now you can optimize this by using SO* instead of plain cols as SORelatedJoin instead of RelatedJoin,etc. > Is it slow because it doesn't pre-compile queries, or is it because of > the actual query-text it uses? Can its performance be boosted by > judicious use of indices, etc? > it does precompile, it also catches. > And the final question: is SQLAlchemy any better in this regard? I'm > liking SO right now, because of things like paginate and Catwalk. So > I'm wondering, how hard is it to transition an existing site (with > database) from SO to SA? > you can hop on top of activemapper and the changes are close to none. doing the changes to full port to the regular mapper is not a big deal either. > Thanks everyone, > > Stuart > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
