title: Sqlite - how to use more memory and cache, and make it run faster
body: <p>I'm inserting into a table in Sqlite around 220GB of data,</p>
  
  <p>and I noticed it use a lot of Disk I/O, read and write,
  but doesn't use the computer's memory in any significant way,
  though there is a lot of free memory, and I don't use commit to often.</p>
  
  <p>I think the disk I/O is my bottle neck not CPU nor Memory.
  how can I ask it to use more memory, or insert in bulk so it could run faster?</p>