Hi,

I have the following model [pseudo code]:

db.Model("podcast", {
   name: StringProperty,
   description: TextProperty,
   homePageURL: StringProperty,
   addedDate: DateProperty
});

db.Model("category", {
   name: StringProperty,
   podcastsNumber: IntegerProperty
});

db.Model("podcastcategory", {
   category: ReferenceProperty({referenceClass: Category}),
   podcast: ReferenceProperty({referenceClass: Podcast})
});

I am trying to query the datastore to show in the web page the latest
5 podcasts in a certain category.

Problem is my approach seems very costly:

I do a query against podcastcategory and get al lentities there
filtered by my category property.
and i get all podcasts.
then I would have to sort them in my app by addedDate.

I feel that something is wrong, maybe my query or my data modelling. I
would appreciate any advice or links to set me to the right direction.

cheers,
Gabi

-- 
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 [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-java?hl=en.

Reply via email to