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. On Jan 24, 1:17 am, George Sudarkoff <[email protected]> wrote: > I have a bit of a problem coming up with an efficient data model/algo > for a project I am working on: > > I have a few hundred items, each tagged with zero or more tags. I need > to be able to fetch items that, for example, are tagged with tag1 AND > (tag2 OR tag3) AND NOT tag4. > > Any help would be greatly appreciated! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
