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.
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.
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.
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.
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
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.
The maximum size allowed for an item in Dynamo DB is 400KB. This is mentioned here
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With