Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

maximum field and item size limits in dynamo db and mongo db

I want to use dynamo DB to store some attributes which are big string values...

Is there any maximum field size/maximum item size limitation in Dynamo DB? Something which limits the data that i store for 1 item in a table?

Also, what is the equivalent limit (if any) in Mongo DB?

I am evaluating these 2 nosql databases as possible solutions for one of my applications. Any advice/inputs you could give would be appreciated.

like image 248
Arvind Avatar asked Feb 07 '12 16:02

Arvind


People also ask

What is the maximum item size in DynamoDB?

Item size. The maximum item size in DynamoDB is 400 KB, which includes both attribute name binary length (UTF-8 length) and attribute value lengths (again binary length). The attribute name counts towards the size limit.

How many items can DynamoDB have?

In DynamoDB, there is no limit to the number of items you can store in a table. Attributes – Each item is composed of one or more attributes. An attribute is a fundamental data element, something that does not need to be broken down any further.

What is difference between DynamoDB and MongoDB?

Both these databases support multi-document transactions, but with key differences: MongoDB supports read and writes to the same documents and fields in a single database transaction. DynamoDB lacks support for multiple operations within a single transaction.


3 Answers

The MongoDB limit is currently 16MB per document, this has increased a couple of times over the course of development, but that is the limit as of the current release (2.0.x at the time of writing), see here:

http://www.mongodb.org/display/DOCS/Documents

I'm not as familiar with the various limits in Dynamo, but you can find a list of them here:

http://docs.amazonwebservices.com/amazondynamodb/latest/developerguide/Limits.html

like image 93
Adam Comerford Avatar answered Sep 30 '22 20:09

Adam Comerford


DynamoDB max per item is currently 64k (which is seen by many as a serious shortcoming). Best practice for documents larger than 64k would be to store a pointer to document (S3?) instead of the entire document, but this obviously has some associated issues as well.

like image 43
Nick Avatar answered Sep 30 '22 19:09

Nick


The maximum size allowed for an item in Dynamo DB is 400KB. This is mentioned here

like image 42
theBuzzyCoder Avatar answered Sep 30 '22 19:09

theBuzzyCoder