On Jan 25, 11:43 am, Anthony <[email protected]> wrote: > If you store the tags as a StringList wouldn't this query work.. > > WHERE tags = tag1 AND tags IN [tag2,tag3] AND tags != tag4 > > From the docs it says the IN & != do run multiple queries behind the > scenes so not sure if it will be as quick as running it in memory for > a few hundred items, but if you need more than a few hundred items you > are not going to be able to do it in memory before it starts timing > out.
good call, anthony! that query does indeed do what george wants, and you're right about how != and IN work behind the scenes. the problem with that query, unfortunately, is that it needs this index: - kind: Foo properties: - name: tags - name: tags - name: tags ...which is almost certain to explode on entities with any more than a handful of tags: http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html#Big_Entities_and_Exploding_Indexes --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
