title: How to create indexes faster
body: <p>I have a table of about <strong>60GB</strong> and I'm trying to <strong>create an index</strong>,
  and its very slow (almost a day, and still running!)</p>
  
  <p>I see most of the time is on Disk I/O(4MB/s), and it doesn't use the memory or cpu so much</p>
  
  <p>I tried: running 'pragma cache_zise = 10000' and 'pragma page_zise=4000'
  (after I created the table), and its still doesn't help.</p>
  
  <p><strong>How can I make the 'create index' run in reasonable time?</strong></p>