Skip to content

Instantly share code, notes, and snippets.

@peijiehu

peijiehu/nosql.md

Last active July 16, 2017 23:09
Show Gist options
  • Save peijiehu/8a43d64f6e068f9dde1c5cc9797f13e3 to your computer and use it in GitHub Desktop.
Save peijiehu/8a43d64f6e068f9dde1c5cc9797f13e3 to your computer and use it in GitHub Desktop.
Download ZIP
When to use NoSQL(eg. MongoDB)
Raw
nosql.md

start by asking yourself the following questions:

  1. is your data format not well defined and likely to change - add fields that you don't know yet? Adding field in rdbms may lock the db or affect performance.
  2. is the data going to be big? 5-10 gb table in MySQL will not work efficiently.
  3. high insert load?
  4. nature of the data, eg. geo data that you want to query by locations, mongo has support

MORE ON: dzone post - when to use mongo rather than mysql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment