On Sun, Mar 25, 2012 at 11:04 AM, Gopal Patel <[email protected]> wrote: > > I would also like to know if someone out there is making highly complex > system on top of google app engine ? ( By Complex, I mean, lots of cross > entity transaction, more than hundred different tables, complex relationship > with tables) and they are successful in doing so.
You sound like someone who wants to force a highly normalized SQL schema into the GAE datastore. It's not going to work. You model things differently with the datastore; table count is a poor metric. For example, I have a schema with 13 different 'kinds', most of which are polymorphic and have varying levels of embedded hierarchical structure. In a relational world, this might expand to 30-40 tables depending on how you managed the polymorphism. You'd tend to do a lot of joins to get answers. With a data model designed for GAE's strengths, I usually get all relevant data in 1 or 2 rounds of fetch-by-key. A better metric is: How many tables do you have to join across in a single query? That's the kind of complexity that will cause you pain on appengine. Jeff -- 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.
