Hi Robert, Thanks for your answer. If the number of results returned by each filter individually is smaller than, let's say 1000, the "final" number of results will be returned correctly? I want to know if there are some known limits for this type of query on a single list property (maybe for the size of the list, for the number of the results returned by each filter, for the number of filters, etc...). I didn't find the answer for this question. In all queries that returns datastore need index exception I have one filter that returns almost 90000 entities and one that returns < 500 results. But I have also many queries with 3 filters (90000 results, 50000 results, 50000 results) that returns the correct results.
Hi Andrei, Yes, almost the same queries: the difference is that in the second table I have a single list property. This list contains the rest of fields from the first table. I tried to limit the number of the results from datastore viewer but with the same result :(. On Apr 14, 5:03 pm, Andrei Cosmin Fifiiţă <[email protected]> wrote: > And also, i limit the number of results (for ex when implementing > pagination)... Does that affect the success of the query ? > > 2011/4/14 Andrei Cosmin Fifiiţă <[email protected]>: > > > > > > > > > I don't want to create custom indices cause they will fail... but does the > > order of the equality filters matter? > > > On Apr 14, 2011 3:38 AM, "Robert Kluin" <[email protected]> wrote: -- 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.
