App Engine's datastore is backed by a key-value store. To do a delete of 1000 values, App Engine needs to iterate over 1000 indexes, then issue a batch delete command. Could this be a cold start? Even if it is/isn't, it may make more sense to hand it off to a task queue. App Engine favors a denormalized model over RDBMS normalization.
-- Ikai Lan Developer Programs Engineer, Google App Engine Blogger: http://googleappengine.blogspot.com Reddit: http://www.reddit.com/r/appengine Twitter: http://twitter.com/app_engine On Thu, Oct 21, 2010 at 2:47 AM, john b. <souslera...@gmail.com> wrote: > Disclaimer: i am very new on GAE/J > > I have a single persistent object class (10 fields of type int/String/ > date) for which i removed indexing on all fields except the PK which > is a string (these objects are around 60 bytes if serialized in > protobuf so pretty small). > > Now i run into a request timeout issue trying to delete all objects > (around 1000) in the db: > > PersistenceManager pm = PMF.get().getPersistenceManager(); > String query = "select from " + SomeJDO.class.getName(); > pm.newQuery(query).deletePersistentAll(); > pm.close(); > > I get timeout report for the request and the log gives: 30915ms > 31202cpu_ms 19302api_cpu_ms. > > My project is no more than a toy application and a deleting 1000 > vanilla rows does not seem much even on a desktop database. > > What am i doing wrong? > > -- > 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-appeng...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com> > . > 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 google-appeng...@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.
