You should read http://code.google.com/appengine/docs/java/datastore/queriesandindexes.html#Introducing_Queries
Specifically "Query Filters" and "A single query containing != or contains() operators is limited to 30 sub-queries." || is mapped to 'contains()' On 27 July 2010 19:53, Mark <[email protected]> wrote: > Hi, > > I'm interested in knowing how well multiple OR (||) statements would > operate in a single query. For example, I want to find all friends > that have recommended a particular product: > > Query query = pm.newQuery(Recommendation.class, > "(username == 'turtle' || > username == 'frog' || > username == 'rock') && > productid == '123'"); > > if a user has 200 friends, and I created a huge string as above, what > can I expect to happen? Should the query take a very long time to run? > Can app engine break the query apart and run each part in parallel? > Even if performance is ok, will I be using a lot of my CPU quota every > time this is called? > > Thanks > > -- > 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. > > -- 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.
