This may be due to your repeated property. Depending on your query on this property, you may not have the required indexes for a fast result. Therefore the Datastore would attempt a zigzag merge join on existing indexes in attempts to satisfy the query. As per the documentation, this could indeed lead to poor performance <https://cloud.google.com/appengine/articles/indexselection#Performance>, and it is recommended to plan out your indexes according to your queries.
You can test the above by removing the repeated property from your query to see if it improves performance. If it is still slow, than this may simply be an issue with your App Engine code (since you mentioned that this query works in the Datastore Console). To investigate your application, you can use the Stackdriver Trace <https://cloud.google.com/trace/>tool to see why your requests are hanging and where all of the time is being spent. - Note that Google Groups is reserved for general product discussions and not technical support. For further support in improving your Datastore queries it is recommended to post your detailed questions <https://stackoverflow.com/help/how-to-ask> (along with the actual queries) to Stack Exchange <https://cloud.google.com/support/docs/stackexchange> using the supported Cloud tags. -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/baab7b33-6973-49b0-a089-716247df40c8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
