Improve the response time of AWS Dynamodb
<p>We have been using Couchbase for about two years but we finally decided to switch to Amazon DynamoDB service for many reasons.<br>
Now I started the migration of data to dynamodb. First everything was alright and going as expected, but after some time the response time from dynamo is getting higher and higher and the migration process is getting slower by time.<br>
I tried to change my strategies but with no luck.<br>
What can I do to increase the response time?</p>

<p>Basically I am scanning an SQL table getting 100 items per query then asking Couchbase to retrieve the data I want about these 100 items. At first I was getting high response times (as shown in the image bellow).</p>

<p>The following info might help:</p>

<ul>
<li>I am running the migration code on an ec2 micro server running Ubuntu 14.04 with node v 4.4.1.  </li>
<li>After looking at the graphs I started measuring the time for each dynamodb request (so I don't know what is the average was at first), the average response time is 800 ms for about 150,000 requests (get &amp; put only, no batch commands or queries)  </li>
<li>I am storing the items in two tables one with integer hash key and the other is with integer hash and sort keys </li>
<li>The second table is a huge one (having about 4.4 millions of items and counting)</li>
</ul>

<p><a href="https://i.stack.imgur.com/asFgM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/asFgM.png" alt="An image shows how the consumed capacity decreased overtime"></a></p>