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. 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? 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? 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 -~----------~----~----~----~------~----~------~--~---
