Why isn't denormalization a real option? A lot of companies denormalize with great success, including Google.
The thing about joins is this: they have to happen at some point in memory. Datastore or local instance. -- Ikai Lan Developer Programs Engineer, Google App Engine plus.ikailan.com | twitter.com/ikai On Thu, Aug 4, 2011 at 6:00 PM, William Levesque <billleves...@gmail.com>wrote: > Alright, so I've spent a lot of time contemplating this whole BigTable > isn't relational limitation. I've tried two techniques for joining > different tables. The solution described here... > > http://gae-java-persistence.**blogspot.com/2010/03/** > executing-simple-joins-across-**owned.html?showComment=**1298589845909#** > c7562859098617623831<http://gae-java-persistence.blogspot.com/2010/03/executing-simple-joins-across-owned.html?showComment=1298589845909#c7562859098617623831> > > and joining with loops inside my code. The former eats a lot of CPU, the > latter is just silly. Denormalizing isn't a real option. There are very > good reasons normalization was developed. > > So I'm trying to get a definitive strategy from Google that is considered > the best way to support a system with complex data relationships. I > appreciate your help. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-appengine-java/-/UCYoAoRaI6QJ. > To post to this group, send email to > google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.