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 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 use cursors instead -- 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-appengine@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.