Re: [google-appengine] How to do a 'count' in App Engine

2011-07-03 Thread Robert Kluin
If this is something you will be needing often, you should try to precompute the count. You could do it at write time or periodically in the background. It will be much more efficient. Robert On Jul 1, 2011 1:01 PM, Droid rod...@gmail.com wrote: Basic question which I cannot solve: SELECT *

[google-appengine] How to do a 'count' in App Engine

2011-07-01 Thread Droid
Basic question which I cannot solve: SELECT * FROM MyWords where bookname = 'book1' how can I simply count the number of returns? (I bet its easy eh?) Thanks in advance if you take the time -- You received this message because you are subscribed to the Google Groups Google App Engine

RE: [google-appengine] How to do a 'count' in App Engine

2011-07-01 Thread Brandon Wirtz
I would store the result to an array and count the array. That may not be optimal, but usually if I want a result count I wanted the results too, if only to store in memcache. But if you select count(Query) You get just the count for the query. Long Explanation for Java here: