App Engine - ReferenceProperty and custom indexes

Question

This is a follow-up question to Drew Sears' answer to this discussion:

http://stackoverflow.com/questions/3314721/app-engine-datastore-data-model-question

If I model bucket as a reference property in the object kind and say I want to query for objects in bucket 1234 with size > 1000. My query will look like "where bucket = key('Bucket', 1234) and size > 1000".

I'm assuming that this will require a custom index on the bucket and size properties. Is that assumption wrong? If not, is Model #2 in the original question (dynamic kinds) the only way to make it work with automatic indexes? I hope there's another way.

Thanks, Keyur

Answer 1

You're correct: This will require a custom index. Dynamic kinds would be one way around this - though a kludgy one - but there may be others. Can you tell us more about the structure of these entities, the kinds of properties users can declare, and valid queries on those properties?