Truth is, there is no way to "efficiently" truncate a table because of the nature of BigTable - your data isn't stored in separate tables that can be dropped individually. Every row is stored in one big table, and those rows need to be deleted individually.
Sometimes I wonder if Google should simply double the price of a write operation and make delete operations "free". Of course, it makes write operations look really expensive... but they *are* that expensive since all data will eventually get deleted. Jeff On Sun, Dec 2, 2012 at 7:32 PM, Carl Schroeder <[email protected]>wrote: > I am not sure if it is the most efficient, but what I do is: > Remove all indexes associated with the model. This minimizes writes > associated with deletes. > Then create a cron task that deletes n entities per day according to how > much quota I feel like using. > > GAE really needs a "remove all entity and indexes for entity" function. > > > On Sunday, December 2, 2012 3:23:07 PM UTC-8, observer247 wrote: >> >> I have a model (table) which has accumulated a few GBs of data. I do not >> need any of the data and so want to truncate the table. >> >> Yesterday I tried to DELETE ENTITIES using Datastore Admin but it hit my >> billing limit immediately. >> >> What is the cheapest way to truncate a table in Google App Engine ? >> >> PS: I am using python >> > -- > 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/-/YBOQusnZSRcJ. > > 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.
