Hi Big Brains,

I carefully watched the Brett¹s speech about large scale apps and how to use
the list property. I encourage everyone to watch it.

My need : to query on BOTH a single property AND a list property.
This will create a custom index over ONE single property and ONE list
property.

My question : I need to know from your experience if this would lead to
query or index performance issues, knowing that we intend to manage a VERY
large number of those small entities.

Following is a sample example of my model (where I removed all JDO
annotations for clarity) :

Class HelpMeBigBrains {
    private Key key;        // primary key of the object
    private Key objectAkey; // unowned one-to-one
    private List<Key> objectBkeys; // unowned one-to-many
}   

My JDO query would look like this :

Query query = pm.newQuery("SELECT key FROM " +
HelpMeBigBrains.class.getName());
query.setFilter(³objectAkey == aKey²);
query.setFilter(³objectBkeys.contains(b1Key)²);
query.setFilter(³objectBkeys.contains(b2Key)²);
query.declareParameters(³com.google.appengine.api.datastore.Key aKey, b1Key,
b2Key²);
List<Key> results = (List<Key>) query.execute(keyA, keyB1, keyB2);

Thank you in advance for your answer(s).

Kind regards,
Cyrille 



-- 
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