I think the issue is happening because you are ordering the results.
Merge join could be used, but it does not currently work with sort
orders. Alfred Fuller just posted some suggestions on how you might
address this:
http://groups.google.com/group/google-appengine/browse_thread/thread/1d19a1de82
You can perform an AND query on a ListProperty without a custom index.
I think it's called merge-join.
Have you tried InventoryItem.all().filter("keywords =",
keyword1).filter("keywords =", keyword2).filter(...) ?
Julian
http://www.memobuild.com
On Sep 24, 3:56 am, jorge wrote:
> It seems to m
You can perform an AND query on a ListProperty without a custom index.
I think it's called merge-join.
Have you tried InventoryItem.all().filter("keywords =",
keyword1).filter("keywords =", keyword2).filter(...) ?
Julian
http://www.memobuild.com
On Sep 24, 3:56 am, jorge wrote:
> It seems to m
I agree, I'm definitely not happy with the multiple indices. Not to
mention I quickly ran into the exploding index problem. I just
watched the Google I/O video about the Next Gen queries, and it looks
like the issues will be solved in an upcoming release...hopefully that
happens soon. It looks l
I would let the datastore return the "OR" query and then perform the
union in my application code.
If I thought the OR was going to return a huge number of results (too
large to practically process in a single request) I would start a task-
queue task to fetch the data and then have my front-end