> > Unfortunately, I think that the SelectResults extension only works on > "query" objects, and not arbitrary selects like I instructed you to use. > So you are going to have to build a query object to do what you want, > which is to fetch two different mapped objects in one query. The > SQLAlchemy > documentation provides some insight on how to do this (rather advanced) > operation in its section on advanced data mapping: > > http://www.sqlalchemy.org/docs/ > documentation.html#advdatamapping_resultset > > Personally, I have found limit/offset paging to work very poorly on > large > data sets, especially with high offsets. The problems with it are > worsened > if you use MySQL, which has a foolish implementation of offset where all > records are pulled into memory, and then irrelevant ones are just thrown > away. > > Good luck.
Ok then that confirms what I must do. I was hoping i was missing something that would simplify the process. Thanks again for all your help Jonathan. Thanks to you too for your help Gaetan. Mel --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
