[google-appengine] Re: What kind of actions belong to Small Datastore Operations?

2011-11-26 Thread cb
I found that the COUNT query was the killer. Once I removed it, my small op usage went way down. On Nov 8, 4:16 am, Gerald Tan woefulwab...@gmail.com wrote: Most of the time, it's COUNT queries that is causing over-quota for small ops. It costs 1 small op per entity counted. You should use a

[google-appengine] Re: What kind of actions belong to Small Datastore Operations?

2011-11-08 Thread Simon Knott
Hi, Someone asked this just earlier today - https://groups.google.com/d/msg/google-appengine/csrZsowdUmY/CACgb4jWCqUJ Cheers, Simon -- You received this message because you are subscribed to the Google Groups Google App Engine group. To view this discussion on the web visit

[google-appengine] Re: What kind of actions belong to Small Datastore Operations?

2011-11-08 Thread Gerald Tan
Most of the time, it's COUNT queries that is causing over-quota for small ops. It costs 1 small op per entity counted. You should use a counter entity instead, sharding it if necessary. The rest of the time it's using OFFSET + LIMIT queries. Each offset value costs 1 small small op. You should