title: best database for write 1 million rows per second in a single node
body: <p>We have a system that generates 1 million data per second.</p>
  
  <p>we have 1 server and should keep data for 1 week (after 1 week we remove older data)</p>
  
  <p>Each row has a timestamp field, id field and some other fields.</p>
  
  <p>We don't have complex analytic queries, what we want is the database that can handle loading this amount of data and then we can retrieve this data by filtering time and Id (or one or two other columns) from it.</p>
  
  <p>What is the best choice for our case ?  </p>