title: Which Database to use for massive update
body: <p>I need help in select the right Database for my data.
  I have table of usersItems with the following columns:</p>
  
  <pre><code>userId , itemId , attribute1 ,attribute2,attribute3 .......,attribute10
  </code></pre>
  
  <p>There are 1000 users +- , and every user has 100,000 items(avg) . 
  The data in the table updated every 3 hours from  third-party API. (I'm getting file for each user with the updated items.. not all of them really changed).</p>
  
  <p>The data from this table in use as is, without aggregations. Each user can see his items in the website.</p>
  
  <p>Today I'm using mySQL and have few problems with the massive update of records.
  I thought to migrate the data to redshift or  one of the NOSQL dbs.</p>
  
  <p>I'll be happy to hear your recommendations. </p>