20 messages in com.googlegroups.google-appengine[google-appengine] Re: Many-to-many J...
FromSent OnAttachments
arbi...@gmail.com29 Apr 2008 08:19 
Yagiz Erkan29 Apr 2008 08:43 
Jeremey Barrett29 Apr 2008 08:49 
Dado29 Apr 2008 09:15 
arbi...@gmail.com29 Apr 2008 09:50 
Ben the Indefatigable29 Apr 2008 11:06 
arbi...@gmail.com29 Apr 2008 11:19 
arbi...@gmail.com29 Apr 2008 13:25 
Ben the Indefatigable29 Apr 2008 17:01 
Ben the Indefatigable29 Apr 2008 18:33 
arbi...@gmail.com30 Apr 2008 07:22 
Brett Morgan30 Apr 2008 17:36 
cyj03 May 2008 06:27 
arbi...@gmail.com08 May 2008 09:16 
joh...@easypublisher.com12 May 2008 08:58 
Andrew Fong14 May 2008 16:15 
Brett Morgan14 May 2008 17:00 
Andrew Fong15 May 2008 01:14 
Brett Morgan15 May 2008 04:42 
Filip15 May 2008 05:01 
Subject:[google-appengine] Re: Many-to-many JOIN with the Datastore
From:Ben the Indefatigable (bcbr@gmail.com)
Date:04/29/2008 11:06:22 AM
List:com.googlegroups.google-appengine

Using the reference property has also been called a "virtual join" on this forum. You can actually do the select on the intermediary entity without pulling the referenced entities. This is good if you de- normalize the data that you need for your query out of those referenced entities into your intermediary entity (such as LibraryBook above) to avoid pulling the additional entities in your common read cases. A good discussion of many to many joins in the datastore should mostly discuss how to avoid them and find scalable alternatives. :)