I am currently going through the process of deleting 500,000 entities from my datastore.
Here are the different stats I have so far db.delete() for: 100 entities = 2,179 API_CPU 200 entities = 4,345 API_CPU 500 entities = 10,845 API_CPU So.. it doesn't seem like you get better per entity API_CPU for deleting more at once. It seems to average about 21 API_CPU per entity deleted. There doesn't even really seem to be a general time benefit either. It seems to average about 1 to 2 seconds per 100 entities deleted. On Sat, Feb 20, 2010 at 3:21 AM, kang <[email protected]> wrote: > I'm going to clear the datastore. I use the following code: > > old_date = datetime.datetime(2009,10,1) > old_updates = SomeUpdate.all().filter("updated <",old_date).fetch(20) > db.delete(old_updates) > > it costs me nearly 1982cpu_ms 1945api_cpu_ms every time. Is it normal? > > > -- > Stay hungry,Stay foolish. > > -- > 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%[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.
