Just as an FYI if you are constantly deleting entities, there are performance implications. Deleted data is soft deleted and asynchronously deleted off disk at a later time, so it adds some non trivial cost to index traversal times (you are still having to skip all the deleted rows on disk). It's similar to how OPTIMIZE TABLE works in InnoDB for MySQL ( http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html) - the space isn't really reclaimed until we do a table compaction.
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 On Fri, May 13, 2011 at 3:01 PM, Brandon Wirtz <[email protected]> wrote: > Yeah, That's great for a one-off, but I actually want the equivalent of a > memcache flush all that I can Cron. > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Greg Darke > (Google) > Sent: Friday, May 13, 2011 2:22 PM > To: [email protected] > Subject: Re: [google-appengine] Drop Table equivalent? > > The currently recommended way of deleting all entities of a particular kind > is to use datastore admin > ( > http://code.google.com/appengine/docs/adminconsole/datastoreadmin.html#Dele > ting_Entities_in_Bulk). > > If the primary version of your code is not in python, you can upload a > simple application to an alternate version that has datastore admin > enabled. > > On 13 May 2011 13:12, Brandon Wirtz <[email protected]> wrote: > > I know people have asked variations of this question, and the solution > > has always been to drop entities 1000 at a time, > > > > > > > > But have an app that the cleanup code had a misspelling so it never > > did anything except clean things that didn’t exist… > > > > > > > > Is there a “Drop Table” equivalent? Or do I really query 1000 and > > delete over and over. Cause it appears that’s going to be like $100 > > which is fine…. If that is the best solution, but if there is a drop > > table equivalent that is $5 I’d really like that so that I can use it > > in my code that would normally get charged the $100 over 6 months … > > > > > > > > > > > > -- > > 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.
