title: sqlite: Fastest way to get all rows (consecutive disk access)
body: <p>I want to read all rows in a table using system.data.sqlite. As I have a very big Table (>450GB, with > 6 billion rows) I want to be sure that sqlite will use consequtive disk access. As you may know a random access to hard disk is slow. Due to memory restictions I can not load all the data at once. So the optimal way would be if sqlite reads some hundred MB (consecutive), then I work with this data and sqlite reads the next.</p>
  
  <p>How can I be sure that sqlite will do disk access this way and not jumping from one position on hard disk to another?</p>
  
  <p>Things I know (I think these suggestions will show up):</p>
  
  <ul>
  <li>It could be better to use an other DBMS. But I want/need to solve it wiht this one.  </li>
  <li>I know that the disk head will be positioned by the OS on other data while I am workign with thhe data. This doesn't matter. It is just that some hundret MB will be read consecutively.</li>
  <li>I don't want to / can split the database file up into smaller pieces</li>
  </ul>
  
  <p>I found this post, but it is not addressing my problem correctly:<br>
  <a href="https://stackoverflow.com/questions/2947165/which-is-the-fastest-way-to-retrive-all-items-in-sqlite">Which is the fastest way to retrieve all items in SQLite?</a></p>