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 <johnter...@gmail.com> 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 google-appeng...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://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 google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
