> But 秦锋 I think is referring to AND, the code in the quoted post is > only pseudo code (and/or gql expands to 'and' internally - sorry, I > dont know enough python)
Why do you think that "WHERE tags = :1, inputTags (it's a list)" is pseudo code? It looks to me like an excerpt from query construction code together with a description. The :1 isn't python-specific, it's a convention in the API for query construction. It means "the first argument after the query string". If the query string ended with ":1", the comma would separate it from the first argument, which I take to be the value of inputTags, which is described as being a list. Where are you finding something relevant in GQL which expands internally into an AND? Maybe 秦锋 will post the actual code. On Apr 5, 1:04 pm, Barry Hunter <[email protected]> wrote: > That thread is refering to 'in' which effectivly is a OR - which as > pointed out by ryan expands to three(or multiple) queries under the > hood. > > But 秦锋 I think is referring to AND, the code in the quoted post is > only pseudo code (and/or gql expands to 'and' internally - sorry, I > dont know enough python) > > a query of "WHERE tag = 'tag1' AND tag = 'tag2' AND tag = 'tag3' " - > will require *three* indexes on `tag` > > - this only make sense for ListProperties. But is a valid query. For > Lists, " tag = 'tag1' " could be written like " ('tag1' IN LIST `tag`) > " - which is different to the sql/gql IN keyword. > > On 05/04/2009, Andy Freeman <[email protected]> wrote: > > > > > > > > > Something is wrong here - it should not generate multiple indices per > > tag, regardless of the length of the list. (The query won't work if > > the length is greater than 30, but that's a different problem.) > > > see Ryan's message in > > > http://groups.google.com/group/google-appengine/browse_thread/thread/... > > > That time, the problem turned out to be some user error, but I didn't > > see an explanation. > > > On Apr 3, 8:58 am, 秦锋 <[email protected]> wrote: > > > Alkis: > > > I re-check my code and found if I use list property in gql like > > > following: > > > > WHERE tags = :1, inputTags (it's a list) > > > > If there are 3 tag in inputTags, index will be: > > > > name:tag > > > name:tag > > > name:tag > > > > Does this cost huge space? > > > > But it's really cool for multi-tags searching in app! > > > > On 4月3日, 下午8时50分, Alkis Evlogimenos ('Αλκης Ευλογημένος) > > > > <[email protected]> wrote: > > > > What do your models look like? > > > > > On Fri, Apr 3, 2009 at 2:00 PM, 秦锋 <[email protected]> wrote: > > > > > > My App: cndata4u.appspot.com > > > > > Now I have imported about 2500 records there, and with only THREE > > > > > entities. But I have found that these data have occurred 20% data > > > > > store, about 200M! > > > > > My original CSV files have only 308K! > > > > > > Any idea? > > > > > -- > > > > > Alkis- Hide quoted text - > > > > - Show quoted text - > > -- > Barry > > -www.nearby.org.uk-www.geograph.org.uk-- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
