Hi, I guess if you will use bulk delete it would help:
delete_me = [] for item in Model.all(keys_only=True): delete_me.append(item) db.delete(delete_me) //wbr Pashka R. <pashka.rezni...@gmail.com> On Mon, Jul 13, 2009 at 20:45, Tony<fatd...@gmail.com> wrote: > > There is no such option, but something that will speed up your deletes > significantly is to do a keys_only query. The query you are currently > using fetches all 300 entities into memory (including their > properties, etc) - but you only need the key to delete the entity. > Try something like "query = Homedata.all(keys_only=True)" and you > should be able to delete more entities per batch for less cpu. > However, it's still going to be a long and cpu-intensive operation for > 25000+ entities. > > On Jul 12, 12:53 pm, jacqueslep <jacquesle...@gmail.com> wrote: >> Hello, >> i try to delete all records in a datastore, a simple table with a time >> serie of int values >> there are more than 25000 entries >> >> when i do : >> >> homedata_query = Homedata.all() >> homedatas = homedata_query.fetch(300) >> db.delete(homedatas) >> >> if the fetch count is greater then 300 i receive a timeout >> so i have to repeat this a huge number of time >> >> it did take me about 20 min to do that >> and it cost 2.38 CPU hours because the CPU sec used /sec was up to 8 >> This is not useable, i want to store (and be able to delete) more than >> 100k entries, >> deleting 300 by 300 would take more than one hour to complete and cost >> 8h of cpu >> >> what is the trick to instant delete, like the -c option in the App >> Engine SDK ? >> >> btw can someone explain how the cpu sec used /sec are computed > > > --~--~---------~--~----~------------~-------~--~----~ 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-appengine@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 -~----------~----~----~----~------~----~------~--~---
