hi all, i'm playing with appengine's data models and i've just hit a little bump in the road:
my classes are Group and User, I have many groups and many users. a user can belong to a group, and so I've used a ReferenceProperty from the user to the group which gave me a set of users in the group for easy retrieval. now I have a page that wants to show all the groups (lets say 50 groups) and for each group the list of users in that group. If i just get the rooms and for each room iterate over the set-of- users, this generates a new query per each group and is very slow. what's the best way to handle this? * should i store the relation in a new entity, then query for all the groups, users and relationships, build some python dictionaries and reconstruct the whole thing in python? * should i denormalize the whole thing? how? i'd still want to group the whole thing by Group, should I do that with python dictionaries? thanks a bunch, ohad --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
