Hi Nick, I can't use key_names since twitter ids are not the key_names for my user models The users don't have to oauth to twitter or other sites.
Robert/Niklas, I'll try getting all the users and do a reference query. Thanks guys John On Sep 7, 3:39 am, "Nick Johnson (Google)" <[email protected]> wrote: > Hi John, > > On Tue, Sep 7, 2010 at 1:01 AM, johnterran <[email protected]> wrote: > > Hi Robert, > > > I can't use the key_name. The ids are not from my site > > i.e. > > Lets say the ids are from twitter. I want to know how many of the > > twitter users > > are registered on my site. So the ids can exists in the datastore, > > but it doesn't have to. > > This doesn't prevent you using the IDs as key_names. Attempting to fetch an > entity that doesn't exist will simply return None for that entity. > > -Nick Johnson > > > > > > > > > Is the best way to get all the users and filter them manually similar > > to what Niklas wrote? > > > Thanks > > John > > > On Sep 6, 8:22 am, Robert Kluin <[email protected]> wrote: > > > It will not be possible to use IN for something like that. IN will > > > execute a series of queries, and it is is capped at 30. > > > > If possible, I would suggest you make the entity key_name the user's > > > id. Then you can just build a list of keys and fetch those -- but I > > > really doubt you'll get anything close to 10K on a single fetch. > > > > Robert > > > > On Mon, Sep 6, 2010 at 04:51, johnterran <[email protected]> wrote: > > > > Hi > > > > > In BigTable, what is the most efficient way to do a large IN query? > > > > My IN parameter list is typically 500 but can be 10k+ > > > > i.e. > > > > class User(db.Model): > > > > name = db.StringProperty(required = True) > > > > id = db.StringProperty(required = True) > > > > > given a list of ids that can consist of 10k list, i need to retrieve > > > > all the names > > > > users = db.GqlQuery("SELECT * FROM User where id IN :1", > > > > ids) > > > > > what is the best way to do this? > > > > > Thanks > > > > John > > > > > -- > > > > 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]<google-appengine%2Bunsubscrib > > [email protected]> > > . > > > > For more options, visit this group athttp:// > > groups.google.com/group/google-appengine?hl=en. > > > -- > > 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]<google-appengine%2Bunsubscrib > > [email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-appengine?hl=en. > > -- > Nick Johnson, Developer Programs Engineer, App Engine Google Ireland Ltd. :: > Registered in Dublin, Ireland, Registration Number: 368047 > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number: > 368047 -- 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.
