Hi, I am hitting a performance wall with SQLObject. I use MyClass.select() to display 100 records on a page. The problem is that besides 1 query to fetch the records, 1 query per record is executed to get the properties of every object. That makes 101 queries to display a simple page :(. Are there any tricks to pre-populate the objects, based on a data from the main query? If no, I was thinking of using plain SQL, and creating some dict/list wrapper to pretend every row to be MyClass-compatible. There are several templates that use the same selectresults and changing them all to use list / dict would be a chore...
thanks Ksenia. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
