Hi, The Dashboard indicates me that one of my query is using large amounts of CPU and might exceed its quota. It is displaying usually in red and sometimes yellow (it's using 900-1300 cpu ms, response time is 400-900 ms, with rare peaks at 1400 ms).
These amounts were higher before before the following optimizations: - Attribute prefetching - stopping doing queries in loop (this saved me about 300 ms) - render individual results in memcache - limiting results to 10 (showing 25 results cost about 1000 more cpu ms and 300 ms of response time, even with rendering cache). Despite I have improved latency and reduced cpu ms, I am not compeletely satisfied with these results, and I believe there is some room for more optimization. I would like to count the number of queries for a page, is there an API that I can use for that. I tried Appstats without success (after configuration, the stats page displays correctly but non stats) I would like to find a way to moitor the queries. And if possible make appstats working. Thanks for your interset -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
