[appengine-java] Re: A question about queries and composite indices

2010-09-14 Thread Nickolay Tzvetinov
And one more thing, I'm limiting the query up to 100 results... -- 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 google-appengine-j...@googlegroups.com. To unsubscribe from this group, send email

[appengine-java] Re: A question about queries and composite indices

2010-09-16 Thread Nickolay Tzvetinov
An exact example is "SELECT __key__ FROM SearchIndex WHERE searchables = ^_hidden:::false_^ AND searchables = sex AND searchables = repeat AND searchables = mate AND searchables = feed AND searchables = sugar AND searchables = rating:1". Executing this query I get the exception when the entities i

Re: [appengine-java] Re: A question about queries and composite indices

2010-09-16 Thread Ikai Lan (Google)
The issue here is zig zag merge join. It's a bit more complex subject than I can easily explain in email, but to sum things up, what's happening is that we take multiple indexes and zig-zag between them to generate your result set. When this takes too long, that causes that exception to be thrown.

Re: [appengine-java] Re: A question about queries and composite indices

2010-09-19 Thread John Patterson
On 16 Sep 2010, at 21:18, Ikai Lan (Google) wrote: The way an AND query works is by making multiple queries and merging the results by zig-zagging between them. A solution to your problem may be simply to whittle down the result set to as small as you can reasonably get it, then traverse t