Datastore Read Operations and IN clause

[Pablo Castilla]

Hello,

I would like to know the exact definition of "Datastore Read Operations", I haven't found an official one.

Also I would like to know if I query with an IN clause if it just count as 1 or as the number of elements of the filtering list in the Datastore Read Operations counter.

Thanks in advance

[Amy Unruh]

Pablo,

An 'IN' operator is implemented as a set of queries, one for each item in the list, and so the cost will be for the set.

(You can see this reflected in appstats).

  -Amy

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/xnwBqvhObl0J.
To post to this group, send email to google-a...@googlegroups.com.
To unsubscribe from this group, send email to google-appengi...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.

[Pablo Castilla]

Just for clarifying... if I have an IN with 20 elements in the list, would the data store read operations increase in 20?

Thanks.

[Barry Hunter]

Yes, a IN with 20 elements, will need 20 actual queries performed
against the datastore.

> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To view this discussion on the web visit

> https://groups.google.com/d/msg/google-appengine/-/e-KW-DN95UkJ.