On Sep 6, 8:51 am, 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
I propose parametrize pairs to a dictionary using Query and not GQL ie
User.All( ...+ logic
ie filter("url id", ['www.domain010703.com.','domain010703']) with IN
pairs listed as dictionary. I didn't program it but the data structure
seems adequate.
Thank you
Niklas R
--
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.
