Deleting ALL ItemsName() in a single Query in SimpleDB

Question

HI,

I want to delete all ItemNames in single query in simpledb. whether it's possible in simple db.If possible please give the query for deleting all items in simple DB

Thanks senthil

score 8 · Answer 1 · answered Aug 26 '10 at 15:21

8

SimpleDB doesn't have any way to delete multiple records with a single query, and there is no equivalent to 'TRUNCATE TABLE'.

Your options are either to delete records one at a time or to delete the entire domain.

answered Aug 26 '10 at 15:21

Scrappydog

2,864
1
21
23

Creating a domain takes around a second from my dev box, deleting likewise. This is killing the performance of my tests! – Duncan McGregor Sep 16 '14 at 09:34

score 6 · Answer 2 · answered Sep 01 '10 at 03:46

6

Use the DeleteDomain operation to delete an entire domain. You can re-create the domain using CreateDomain afterward.

answered Sep 01 '10 at 03:46

Stephen McCarthy

611
6
5

score 4 · Answer 3 · answered Dec 27 '10 at 19:12

4

SimpleDB supports batch delete now: http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/SDB_API_BatchDeleteAttributes.html

But you can only do 25 at a time.

If you want to delete the entire domain, do as Scrappydog suggest and delete the domain. Much faster than deleting one by one.

answered Dec 27 '10 at 19:12

Travis Reeder

38,611
12
87
87

Travis, the API says that AttrName and AttrValue are "required" -- I don't understand how to make batched delete queries with just item names. Any pointers? – Riyad Kalla May 06 '11 at 16:42

Deleting ALL ItemsName() in a single Query in SimpleDB

3 Answers3