Hi Robert, Thanks for you being interested to help me.
Let me tell my long sad story: I have Java appengine app. The app has only one page. This page performs search with various parameters, fetches 11 entities and displays search result. My app has 3400 page views per day and each day it exceeds it's datastore read quota. Lets count: (11 entities + 1 query) * 3400 = 41800 41800 is nearly 50000 (I have not counted other pages) This looks ok. After this I added memcache with refresh interval = 1 hour. But I am still getting datastore read quota exceeding. Appstats reports the following data: user.CreateLoginURL 674 datastore_v3.RunQuery 311 memcache.Get 309 memcache.Set 150 datastore_v3.Put 34 datastore_v3.Get 20 blobstore.CreateUploadURL 14 datastore_v3.Delete 8 mail.Send 3 Appstats data is not clear to me. According to docs it describes recent 1000 requests or so. user.CreateLoginURL is called on each page, so appstats describe 674 page requests datastore_v3.RunQuery=311 But why memcache.Set = 150? It should be = 311= datastore_v3.RunQuery = cache miss count Perhaps appstats is not the app which can provide exact numbers. My question is: do you have an idea why my app still get's datastore read quota exceeding even after memcache introducing? -thanks, Andrew On Tue, Jan 31, 2012 at 7:51 AM, Robert Kluin <[email protected]>wrote: > Hey Andrew, > What symptoms are you seeing exactly? > > > Robert > > > > > > On Mon, Jan 30, 2012 at 05:48, Andrew Osipenko <[email protected]> wrote: > > Hi Robert, > > > > no, > > session disabling is the first thing I did to reduce datastore access > count. > > See > > > http://code.google.com/p/rent-map/source/browse/trunk/trunk/src/main/webapp/WEB-INF/appengine-web.xml > > > > Second thing I did was memcache introducing. So I used all standard > > datastore friendly technics. > > > > > > On Mon, Jan 30, 2012 at 7:33 AM, Robert Kluin <[email protected]> > > wrote: > >> > >> Are you using sessions? > >> > >> > >> > >> > >> > >> On Sun, Jan 29, 2012 at 05:37, Andrew Osipenko <[email protected]> > wrote: > >> > Hi Frank, > >> > > >> > Have you solved it? > >> > > >> > I have nearly the same problem. > >> > > >> > I think that appstats do not count some datastore read operations. I > >> > thought > >> > my application accessed datastore during intialization before appstat > >> > filter > >> > is being invoked. But I can't find anything bad during my app > >> > initialization. Do you have any ideas? > >> > > >> > -- > >> > 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/-/Tr6-P0a_XWAJ. > >> > > >> > 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. > >> > >> -- > >> 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. > >> > > > > -- > > 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. > > -- > 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. > > -- 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.
