Sid Anand, Netflix cloud engineer, shares a set of tips for optimizing access to SimpleDB based on his extensive experience using it:
I’ve been a heavy-user of SimpleDB since January 2009, storing, writing, and reading billions of items. Based on my experience, I’ve compiled a list of best practices and conventions to simplify working with SimpleDB.
His article talks about handling numerical and time data, UUIDs/GUIDs, composite value attributes, batched PUTs and a couple more tricks.
Update: Now the original post got split in three parts: ☞ part 2, covering tips on case sensitiveness, sharding, non-indexed queries, eventual consistency and batched PUTs, and ☞ part 3 sharing tips on attribute value length, default query limit,