The queries _are_ responsive now. AppID: steprep-demo When: query non-responsive approx. between 12p and 2p PDT yesterday (2010-07-08) - the mapper job ran approx from 11a to 12p Query: SELECT __key__ FROM AccountKeyword WHERE nextUpdateTime < :1 ORDER BY nextUpdateTime ASC (where :1 is now)
(Looks like it's not actually a composite index involved.) Let me know if you need more info, j On Jul 9, 12:39 pm, "Ikai L (Google)" <[email protected]> wrote: > Hi Jason, > > What's your application ID? When did this take place? Can you give me an > example query that was unresponsive? > > Are they still unresponsive now? Note that there was a maintenance period > two days ago. We're expecting increased latencies, though not to the extent > you have described. > > > > > > On Fri, Jul 9, 2010 at 8:08 AM, Jason C <[email protected]> wrote: > > We started with a model with just over 300,000 entities. We ran a > > mapper job and deleted almost all, leaving only 1,500. This took about > > 45 minutes. > > > However, after the job was complete, any queries based on a composite > > index over that model became effectively unresponsive for around 2 > > hours. That is, almost all requests for queries to that composite > > index resulted in a DeadlineExceededError. > > > Is this expected behaviour? If so, should we be throttling mapper jobs > > that do large deletions? > > > Thanks, > > j > > > -- > > 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]<google-appengine%2Bunsubscrib > > [email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-appengine?hl=en. > > -- > Ikai Lan > Developer Programs Engineer, Google App Engine > Blog:http://googleappengine.blogspot.com > Twitter:http://twitter.com/app_engine > Reddit:http://www.reddit.com/r/appengine -- 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.
