Try using a dynamic tree control in your UI - e.g. http://www.smartclient.com/smartgwt/showcase/#tree_databinding_ondemand
Load all your groups, and then whenever you expand a group node, make a separate query for the users of that group. On Dec 21, 7:35 am, ohadpr <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
